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

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *

16 + 15 =