Which two statements are true regarding the EXISTS operator used in the correlated
subqueries? (Choose two.)
A.
It is used to test whether the values retrieved by the inner query exist in the result of the
outer query.
B.
It is used to test whether the values retrieved by the outer query exist in the result set of
the inner query.
C.
The outer query stops evaluating the result set of the inner query when the first value is
found.
D.
The outer query continues evaluating the result set of the inner query until all the values
in the result set are processed.
Explanation: