多选题Which two statements are true regarding the execution of the correlated subqueries？（）AThe nested query executes after the outer query returns the row.BThe nested query executes first and then the outer query executes.CThe outer query executes only once
题目
多选题
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.