Question

Which is a feature of a correlated subquery? a. The outer subquery executes independent of the inner subquery. b. The outer subquery initiates the process of execution in a subquery. c. The inner subquery initiates the process of execution in a subquery. d. The inner subquery executes first.

Answer 1

Answer:

b. The outer subquery initiates the process of execution in a subquery.

B is correct.

Explanation:

The important feature of a correlated subquery is: It must be executed repeatedly because it depends on the value from the outer SELECT, and must execute once for every value that the outer SELECT produces.