When Running a Correlated Subquery,the DBMS ________

question 12

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.