Nested queries can be used like a procedure (Type I nested query)in which the nested query is executed one time or like a loop (Type II nested query)in which the nested query is executed repeatedly.
A) Type I nested query, Type III nested query
B) Type I nested query, Type II nested query
C) Type II nested query, Type I nested query
D) None of the above

Question

Quizplus · Accepted Answer

Type I nested queries are executed only once as a subroutine, whereas Type II nested queries are executed repeatedly like a loop. Therefore, the answer is B, which correctly identifies the two types of nested queries based on their execution patterns. Option A is incorrect as Type III nested queries do not exist. Option C is also incorrect as the order of the types is reversed, which is not the standard way of representing them.

Nested Queries Can Be Used Like a Procedure (Type I