68. The following are the steps for a correlated subquery , listed in random order:
1) The WHERE clause of the outer query is evaluated.
2) The candidate row is fetched from the t able specified in the outer query .
3) The procedure is repeated for the subsequent rows of the t able, till all the rows are processed.
4) Rows are returned by the inner query , after being evaluated with the value from the candidate row in
the outer query .
Identify the option that contains the steps in the correct sequence in which the Oracle server e valuates a
correlated subquery .
A. 4, 2, 1, 3
B. 4, 1, 2, 3
C. 2, 4, 1, 3
D. 2, 1, 4, 3
Answer: C
1) The WHERE clause of the outer query is evaluated.
2) The candidate row is fetched from the t able specified in the outer query .
3) The procedure is repeated for the subsequent rows of the t able, till all the rows are processed.
4) Rows are returned by the inner query , after being evaluated with the value from the candidate row in
the outer query .
Identify the option that contains the steps in the correct sequence in which the Oracle server e valuates a
correlated subquery .
A. 4, 2, 1, 3
B. 4, 1, 2, 3
C. 2, 4, 1, 3
D. 2, 1, 4, 3
Answer: C