Which two statements are true regarding the execution of the correlated subqueries?()
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.
出自:Oracle认证