Question

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

This question was addressed to me during an interview.

My query is from Insertion Deletion Predicate Reads topic in division Concurrency Control of Database Management

Answer 1

Correct answer is (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

To explain: A noncorrelated subquery is subquery that is independent of the outer query and it can executed on its own without relying on main outer query.