Multiple choice technology databases

Which operators can be used for a subquery to return multiple rows? (MCQ)

  1. IN

  2. ALL

  3. <>

  4. ANY
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

When a subquery returns multiple rows, you must use set-based operators: IN checks membership in the result set, ALL compares against every value (e.g., salary > ALL means greater than the maximum), and ANY compares against any value (e.g., salary = ANY means equal to at least one, equivalent to IN). Standalone comparison operators like = or <> cannot directly handle multiple-row results.

Keep practicing — related questions