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 can handle sets. NOT IN, IN, ANY, and ALL work with multiple rows, while single-row operators like =, <>, and LIKE only work with one value.