When running a correlated subquery,the DBMS always uses ________.
A)regular processing
B)nested processing
C)"quick and dirty" processing
D)SQL-92 processing
E)a form of processing that is specific to the DBMS product

Question

Quizplus · Accepted Answer

When running a correlated subquery, the DBMS uses nested processing. This means that the subquery is executed for every row of the outer query. The result of the subquery is then used in the outer query to determine the final result set. This can be less efficient than regular processing, but is necessary when the subquery is dependent on data from the outer query.

When Running a Correlated Subquery,the DBMS Always Uses ________