When Running a Correlated Subquery,the DBMS ________

Multiple Choice

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.