11. The SQL keyword(s) ________ is used with wildcards.

A. LIKE only
B. IN only
C. NOT IN only
D. IN and NOT IN

Show Answer

12. Which of the following is the correct order of keywords for SQL SELECT statements?

A. SELECT, FROM, WHERE
B. FROM, WHERE, SELECT
C. WHERE, FROM,SELECT
D. SELECT,WHERE,FROM

Show Answer

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

A. braces — {…}.
B. CAPITAL LETTERS.
C. parenthesis — (…) .
D. brackets — […].

Show Answer

14. The result of a SQL SELECT statement is a(n) ________ .

A. report
B. form
C. file
D. table

Show Answer

15. Which of the following are the five built-in functions provided by SQL?

A. COUNT, SUM, AVG, MAX, MIN
B. SUM, AVG, MIN, MAX, MULT
C. SUM, AVG, MULT, DIV, MIN
D. SUM, AVG, MIN, MAX, NAME

Show Answer