Which two statements is true regarding the execution of the correlated subqueries? (Choose two.)
A.
The nested query executes after the outer query returns the row.
B.
The nested query executes first and then the outer query executes.
C.
The outer query executes only once for the result returned by the inner query.
D.
Each row returned by the outer query is evaluated for the results returned by the inner query.
B, C
A,D correct
Why??
This is correlated subqueries.
Read more:http://stackoverflow.com/questions/17268848/difference-between-subquery-and-correlated-subquery
A,D
I choose AD