A non-correlated subquery can be defined as ____.
A.
a set of sequential queries, all of which must always return a single value
B.
a set of sequential queries, all of which must return values from the same table
C.
a SELECT statement that can be embedded in a clause of another SELECT statement only
D.
a set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query
I Didnt understood properly…….can any one explain me
The outer query will get a “hit” on what is returned within the inner query. D is correct. Each hit will produce a row in the outer query.
D is correct, the inner query will return the value, and it will then by evaluated by the outer query’s search value.
D
Correct answer is D