Intermediate
SQL
Q54 / 100
What is the purpose of the "EXISTS" operator in a subquery?
Correct! Well done.
Incorrect.
The correct answer is B) Returns TRUE if the subquery returns at least one row, often used for efficient existence checks
B
Correct Answer
Returns TRUE if the subquery returns at least one row, often used for efficient existence checks
Explanation
EXISTS evaluates to true as soon as the subquery produces any row, often allowing the database to short-circuit and avoid scanning all rows, useful for correlated existence checks.
Progress
54/100