Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)
A.
The outer query stops evaluating the result set of the inner query when the first value is found.
B.
It is used to test whether the values retrieved by the inner query exist in the result of the outer query.
C.
It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.
D.
The outer query continues evaluating the result set of the inner query until all the values in the result set are processed.
correlated subquery contains a ref to a table that also appears in outer query.
The subquery cannot be run independently of the outer query.
The subquery depends on the outer query for its values. This means the subquery is executed repeatedly, once for each row, that the outer query returns.
http://www.java2s.com/Code/Oracle/Subquery/UsingEXISTSwithaCorrelatedSubquery.htm
correlated subquery contains a ref to a table that also appears in outer query.
The subquery cannot be run independently of the outer query.
The subquery depends on the outer query for its values. This means the subquery is executed repeatedly, once for each row, that the outer query returns.
Thus. Each row returned by outer query evaluated against inner query
A,C
I have the same idea. AC