Which of the following statements is true concerning subqueries ?
A. Involves the use of an inner and outer query
B. Cannot return the same result as a query that is not a subquery
C. Does not start with the word SELECT
D. All of the mentioned
Answer:A
Which of the following statements is true concerning subqueries ?
A. Involves the use of an inner and outer query B. Cannot return the same result as a query that is not a subquery C. Does not start with the word SELECT D. All of the mentioned
Explanation: Subquery—also referred to as an inner query or inner select—is a SELECT statement embedded within a data manipulation language (DML) statement or nested within another subquery.