Which of the Following Is NOT True in Regard to Writing

Multiple Choice

Which of the following is NOT true in regard to writing a SQL subquery?

A) Most of the time,a subquery is used when you know how to search for a value using a SELECT statement but do not know the exact value.
B) A subquery is usually added in the WHERE clause of the SQL SELECT statement.
C) A SQL subquery is a separate SELECT statement that is nested outside the main SELECT statement.
D) This type of query is an alternate way of returning data from multiple tables and will be performed once for each row of the resulting dataset.