Multiple choice technology databases

Which operator can be used with a multiple-row subquery?

  1. =

  2. LIKE

  3. BETWEEN

  4. NOT IN

  5. Is

  6. <>
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Multiple-row subqueries return multiple values, requiring operators that handle sets: IN, NOT IN, ANY, ALL. Single-row operators like =, <>, and LIKE cannot compare against multiple values. NOT IN correctly filters out rows matching any value in the subquery result set. BETWEEN is a range operator and 'Is' is not valid SQL.

Keep practicing — related questions