Quiz for IN

Q1: What is the purpose of the SQL IN operator?

A. To perform joins B. To group results C. To check if a value exists in a list D. To sort results

Q2: Which SQL operator is used to specify multiple possible values for a column?

A. BETWEEN B. IN C. LIKE D. ALL

Q3: What does the IN operator do in SQL?

A. Checks for equality B. Checks for a range of values C. Checks if a value exists in a list D. Checks if a column is NULL

Q4: Which of the following is a valid use of the IN operator?

A. SELECT * FROM employees WHERE department = IN (10, 20); B. SELECT * FROM employees WHERE department IN (10, 20); C. SELECT * FROM employees WHERE IN department (10, 20); D. SELECT * FROM employees WHERE (10, 20) IN department;

Q5: What will the query return: SELECT * FROM users WHERE age IN (25, 30);?

A. Users aged below 25 B. Users aged above 30 C. Users aged either 25 or 30 D. All users

Q6: Which operator is equivalent to IN (10, 20, 30)?

A. = ANY (10, 20, 30) B. = ALL (10, 20, 30) C. = ONE OF (10, 20, 30) D. = EACH OF (10, 20, 30)

Q7: Which statement is true about IN operator?

A. Can only be used with strings B. Can be used with subqueries C. Only works with numbers D. Is obsolete

Q8: What is returned if the list in IN clause is empty?

A. Syntax error B. No rows returned C. All rows returned D. NULL

Q9: What is the result of: WHERE salary IN (NULL)?

A. All rows with NULL salary B. All rows with any salary C. No rows returned D. Syntax error

Q10: Which clause uses IN to filter rows?

A. GROUP BY B. ORDER BY C. WHERE D. JOIN

Q11: How do you negate an IN condition?

A. NOT LIKE B. NOT IN C. != IN D. != ANY

Q12: Which will return employees in departments 1, 2, or 3?

A. SELECT * FROM emp WHERE dept_id IN (1, 2, 3); B. SELECT * FROM emp WHERE dept_id = (1, 2, 3); C. SELECT * FROM emp WHERE dept_id == (1, 2, 3); D. SELECT * FROM emp WHERE dept_id BETWEEN 1 AND 3;

Q13: What will the condition evaluate: WHERE 5 IN (1, 2, 5)?

A. True B. False C. Syntax Error D. NULL

Q14: Which is correct about IN and BETWEEN?

A. IN is used for ranges B. BETWEEN is used for discrete values C. IN can list non-sequential values D. BETWEEN lists all values explicitly

Q15: Which statement is invalid?

A. WHERE city IN ('New York', 'LA') B. WHERE age IN (20, 30) C. WHERE salary IN () D. WHERE dept_id NOT IN (1, 2)

Q16: Can IN clause be used with string values?

A. Yes B. No C. Only with numeric values D. Only with dates

Q17: Which is better for short lists of values?

A. JOIN B. IN C. GROUP BY D. HAVING

Q18: What does NOT IN return if any value is NULL?

A. True B. False C. NULL D. Depends on context

Q19: Which operator provides the same functionality as IN?

A. = ANY B. = ALL C. != D. IS NULL

Q20: Which query will fail?

A. SELECT * FROM emp WHERE dept_id IN (1, NULL); B. SELECT * FROM emp WHERE dept_id NOT IN (1, NULL); C. SELECT * FROM emp WHERE dept_id IN (1,2); D. SELECT * FROM emp WHERE dept_id = 1;

Q21: Which of the following is true about IN operator?

A. Always returns TRUE B. Can simplify multiple OR conditions C. Only works in SELECT D. Used for sorting