ocp-047-67 evaluate 是评估

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