Which of the following is a feature of a correlated subquery?
A) The inner subquery executes first.
B) The outer subquery initiates the process of execution in a subquery.
C) The inner subquery initiates the process of
D) The outer subquery executes independent
execution in a subquery. of the inner subquery

Question

Which of the following is a feature of a correlated subquery?
A)	The inner subquery executes first.	
B) The outer subquery initiates the process of execution in a subquery.
C)	The inner subquery initiates the process of	
D)	The outer subquery executes independent
execution in a subquery.	of the inner subquery

Quizplus · Accepted Answer

In a correlated subquery, the outer subquery initiates the process of execution in a subquery, and the results of the inner subquery depend on the values from the outer subquery. The inner subquery is dependent on the outer subquery and executes for each row returned by the outer subquery.

Which of the Following Is a Feature of a Correlated