Introduction to SQL – General Questions

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

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

Correct Answer:  A. LIKE only

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

Correct Answer:  A. SELECT, FROM, WHERE

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

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

Correct Answer:  C. parenthesis — (…) .

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

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

Correct Answer:  D. table

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

Correct Answer:  A. COUNT, SUM, AVG, MAX, MIN

Leave A Comment?

13 − 4 =