When running a correlated subquery,the DBMS ________.
A)runs the lower SELECT statement by itself and then sends the results to the upper SELECT statement.
B)runs the upper SELECT statement by itself and then sends the results to the lower SELECT statement.
C)alternates running the lower SELECT statement with running the upper SELECT statement based on each result of the lower SELECT statement
D)Either A or B may be used depending on the query.

Question

Quizplus · Accepted Answer

A correlated subquery is executed repeatedly, once for each row that might be selected by the outer query. It uses the value(s) from the outer query to complete its execution.

When Running a Correlated Subquery,the DBMS ________