When running a correlated subquery,the DBMS always uses ________.
A)regular processing
B)nested processing
C)"quick and dirty" processing
D)SQL-92 processing

Question

Quizplus · Accepted Answer

When running a correlated subquery, the DBMS uses nested processing. This is because a correlated subquery involves performing a query on one table for each record in another table. Therefore, the result of the subquery is dependent on the specific record being evaluated in the outer query, and the processing must be nested to ensure that the correct results are returned.

When Running a Correlated Subquery,the DBMS Always Uses ________