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 table specified in the outer query.
3) The procedure is repeated for the subsequent rows of the table, 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 evaluates 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
Correlated:相互关联 evaluated:估价 candidate:候选人 process:处理
select (select t2.name from t2 where t2.did=t1.did) from t1
()里面的select t2.name from t2 where t2.did=t1.did就是inner outer
而()外面的select (select t2.name from t2 where t2.did=t1.did) from t1 就
属于outer query
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718848/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
