Which three statements about subqueries are true? (Choose three.)
A.
A single row subquery can retrieve only one row but many columns.
B.
A multiple row subquery can be compared using the “>” operator.
C.
A single row subquery can use the IN operator.
D.
A multiple row subquery can use the “=” operator.
E.
A multiple row subquery can retrieve multiple rows and multiple columns.
F.
A single row subquery can retrieve only one column and one row.
Explanation:
A: A single row sub-query can retrieve only one row but many columns.
E: A multiple row sub-query can retrieve one row or multiple rows and multiple columns.
C: A single row subquery can use the “IN” Operator.Although the IN Operator is a multiple row
operator it can be used for comparisons with single-row subqueries and it will not result in an error