Problem Statement

Novartis Campus Assessment - B.Tech A 50-question multiple-choice assessment covering SQL, Python, Pandas, Snowflake, data-analysis judgement and analytical reasoning. Each question is worth 1 point and exactly one option is correct. Suggested time: 50 minutes. --- Q1. A customer support team needs all tickets where the issue description contains the word "refund" anywhere in the text. Which WHERE condition is most appropriate? A. WHERE issue_description = 'refund' B. WHERE issue_description LIKE '%refund%' C. WHERE issue_description IN ('refund') D. WHERE issue_description BETWEEN 'refund' AND 'refund' Q2. What is the output of len("Analytics")? A. 9 B. 8 C. 11 D. 10 Q3. Given the Orders table has Customer values: Alice Bob Alice Charlie What does this query return? SELECT DISTINCT Customer FROM Orders; A. Alice, Bob, Charlie B. Alice, Alice, Bob, Charlie C. 4 D. Error because DISTINCT cannot be used on text columns Q4. Which Python function returns the largest value in a list? A. lar