You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.
A)IS NULL
B)IS TRUE
C)IS EXIST
D)EXISTS

Question

You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.​
A)IS NULL
B)​IS TRUE
C)IS EXIST
D)​EXISTS

Quizplus · Accepted Answer

The EXISTS operator is used to test whether a subquery returns at least one row. If it returns one or more rows, the condition is true, and the main SQL statement is executed. Therefore, D is the best choice as it closely relates to the question prompt.

You Can Precede a Subquery with the ____ Operator to Create