Online Tutorials & Training Materials | STechies.com
Register Login

Which two statements about subqueries are true? (Choose two.)

Shalesh Singh Visen || 01 Mar 2008 1:44 pm || 0

Q.Which two statements about subqueries are true? (Choose two.)

A. A single row subquery can retrieve data from only one table.

B. A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

C. A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.

D. A single row subquery can retrieve data from more than one table.

E. A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

F. A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

Answer: B, D