← Quiz: Subqueries and Views: all 10 questions
Quiz: Subqueries and Views · Question 8 of 10
Why can EXISTS be efficient?
Why can EXISTS be efficient?
- A.It sorts the subquery result
- B.It runs the subquery only once for the whole table, always
- C.It ignores the WHERE clause
- D.It stops as soon as the subquery finds one matching row
Answer & explanation
Correct answer: It stops as soon as the subquery finds one matching row
EXISTS only needs to know whether at least one row exists.
Can you get the rest right without peeking?
Take the timed Quiz: Subqueries and Views quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →