Which two statements are 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.
A, D
I thought it would be B and C…shouldn’t the inner query run first and the outer query compares the results with inner query?