SQL MCQ Questions and answers Page-13 section-1

61.
A subquery in an SQL SELECT statement is enclosed in:

A. parenthesis -- (...).

B. brackets -- [...].

C. CAPITAL LETTERS.

D. braces -- {...}.

A. file

B. report

C. table

D. form

A. all columns of the table are to be returned.

B. all records meeting the full criteria are to be returned.

C. all records with even partial criteria met are to be returned.

D. None of the above is correct.

A. Acts EXACTLY like a WHERE clause.

B. Acts like a WHERE clause but is used for columns rather than groups.

C. Acts like a WHERE clause but is used for groups rather than rows.

D. Acts like a WHERE clause but is used for rows rather than columns.

A. Data types

B. Primary keys

C. Default values

D. All of the above.

1 2 3 4 5 6 7 8 9 10 11 12 13 14