When a subquery is used,____ is(are)evaluated first.
A) the subquery query
B) the outer query
C) both a and b simultaneously
D) whichever query is selected to execute first by the user

Question

When a subquery is used,____ is(are)evaluated first.​
A) ​the subquery query
B) ​the outer query
C) ​both a and b simultaneously
D) ​whichever query is selected to execute first by the user

Quizplus · Accepted Answer

When a subquery is used, the subquery is evaluated first before the outer query. This is because the result of the subquery is used in the outer query to filter or manipulate the data. Once the subquery is evaluated and its result is retrieved, it is used in the outer query to execute the overall query.

When a Subquery Is Used,____ Is(are)evaluated First.​

When a Subquery Is Used,____ Is(are)evaluated First.