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.
E)None of the above describes how a correlated subquery is run by the DBMS.

Question

Quizplus · Accepted Answer

A correlated subquery is executed repeatedly, once for each row processed by the outer query, with the inner query being evaluated using the current row of the outer query.

When Running a Correlated Subquery,the DBMS ________