Introduction to SQL - Technical MCQs

Q1:

A subquery in an SQL SELECT statement:

A can only be used with two tables.

B can always be duplicated by a join.

C has a distinct form that cannot be duplicated by a join.

D cannot have its results sorted using ORDER BY.

ANS:C - has a distinct form that cannot be duplicated by a join.

No answer description is available.