Multiple choice technology databases

Which of the following requires correlated subquery

  1. IN

  2. BETWEEN

  3. LIKE

  4. EXISTS
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

EXISTS is the only operator listed that requires a correlated subquery. The EXISTS predicate checks whether the subquery returns any rows, and it typically needs to correlate with the outer query to be meaningful. IN can use uncorrelated subqueries, BETWEEN and LIKE are not subquery operators.

Keep practicing — related questions