Oracle
1Z0-047 · Question #71
Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
The correct answer is A. The iner query executes after the outer query returns the row. D. Each row returned by the outer query is evaluated for the results returned by the inner query. See the full explanation below for the reasoning.
Question
Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
Options
- AThe iner query executes after the outer query returns the row.
- BThe inner query executes first and then the outer query executes.
- CThe outer query executes only once for the result returned by the inner query.
- DEach row returned by the outer query is evaluated for the results returned by the inner query.
How the community answered
(38 responses)- A76% (29)
- B16% (6)
- C8% (3)
Community Discussion
No community discussion yet for this question.