A non-correlated subquery can be defined as ____.

A non-correlated subquery can be defined as ____.

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


sravanth

sravanth

I Didnt understood properly…….can any one explain me

Ivan T.

Ivan T.

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.

user

user

D is correct, the inner query will return the value, and it will then by evaluated by the outer query’s search value.

seenagape

seenagape

Correct answer is D