EXISTS will take a value of ________ if the subquery returns an intermediate results table which contains one or more rows.
A) FALSE
B) 1
C) TRUE
D) undefined

Question

Quizplus · Accepted Answer

The EXISTS operator in SQL returns a Boolean value of TRUE or FALSE. If the subquery returns an intermediate result table that contains one or more rows, then the EXISTS operator evaluates to TRUE. Therefore, the correct choice is C.

EXISTS Will Take a Value of ________ If the Subquery