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.
Each row returned by the outer query is evaluated for the results returned by the inner
query.
C.
The nested query executes first and then the outer query executes.
D.
The outer query executes only once for the result returned by the inner query.