Which two statements are true regarding the execution of the correlated subqueries?

Which two statements are true regarding the execution of the correlated subqueries? (Choose
two.)

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Abdulali Aliyev

Abdulali Aliyev

A, D

Mridula

Mridula

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?