Quiz for Multiple Row Subquery

Q1: Which clause is used when a subquery returns more than one row?

A. IN B. = C. EXISTS D. LIKE

Q2: Which operator is used with multiple-row subqueries?

A. = B. IN C. BETWEEN D. EXISTS

Q3: What will happen if a subquery returns multiple rows but the outer query uses "="?

A. All rows are returned B. An error occurs C. Only the first row is used D. No rows are returned

Q4: Which SQL clause often contains a multiple-row subquery?

A. SELECT B. FROM C. WHERE D. GROUP BY

Q5: Which of the following operators is NOT valid for multiple-row subqueries?

A. IN B. ANY C. ALL D. =

Q6: What does the ANY keyword do in a multiple-row subquery?

A. Compares to all rows B. Compares to any one row C. Returns all rows D. Ignores duplicate rows

Q7: Which is a correct use of a multiple-row subquery?

A. WHERE salary = (SELECT salary FROM employees) B. WHERE salary IN (SELECT salary FROM employees) C. WHERE salary > ALL employees D. WHERE salary BETWEEN SELECT

Q8: Which clause cannot use a multiple-row subquery?

A. WHERE B. HAVING C. FROM D. VALUES

Q9: What keyword is used to compare a value to every value returned by a multiple-row subquery?

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

Q10: Which is true about multiple-row subqueries?

A. They can return one row only B. They require GROUP BY C. They return more than one row D. They use SELECT * only

Q11: Which subquery can be used to find all employees who earn more than any employee in department 10?

A. SELECT * FROM employees WHERE salary > (SELECT salary FROM employees WHERE dept = 10) B. SELECT * FROM employees WHERE salary IN (SELECT salary FROM employees WHERE dept = 10) C. SELECT * FROM employees WHERE salary > ANY (SELECT salary FROM employees WHERE dept = 10) D. SELECT * FROM employees WHERE salary > ALL (SELECT salary FROM employees WHERE dept = 10)

Q12: Which operator should be used to check if a value is greater than all results from a subquery?

A. > ALL B. < ALL C. > ANY D. = ANY

Q13: Which error occurs when using "=" with a subquery that returns multiple rows?

A. Division by zero B. Invalid syntax C. Subquery returns more than one row D. Foreign key violation

Q14: Which is a valid operator with a multiple-row subquery?

A. IN B. IS C. = D. NOT NULL

Q15: Which type of subquery returns multiple values?

A. Scalar subquery B. Multiple-row subquery C. Correlated subquery D. Inline subquery

Q16: Which operator is best to check for values not present in a subquery result?

A. NOT EXISTS B. != C. NOT IN D. <>

Q17: What does SELECT salary FROM employees WHERE dept_id = 10 return?

A. Single value B. Multiple values C. Null D. Table name

Q18: What should you use if the subquery returns multiple values?

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

Q19: Which subquery type is best for checking a list of IDs?

A. Scalar subquery B. Multiple-row subquery C. Single-row subquery D. Correlated subquery

Q20: What is the difference between IN and ANY?

A. They are identical B. ANY is used with operators like >, <, etc. C. IN supports only numbers D. IN works inside SELECT clause

Q21: Which subquery returns multiple rows and is used with comparison operators?

A. Scalar subquery B. Single-row subquery C. Multiple-row subquery D. Null subquery