Question

The EXISTS keyword will be true if:

(a) Any row in the subquery meets the condition only

(b) All rows in the subquery fail the condition only

(c) Both of these two conditions are met

(d) Neither of these two conditions is met

I have been asked this question during an internship interview.

This intriguing question comes from Aggregate Functions and Nested Subqueries topic in division SQL : Queries, Constraints and Triggers of Database Management

Answer 1

The correct answer is (a) Any row in the subquery meets the condition only

For explanation: EXISTS keyword checks for existance of a condition.