Database - Introduction to SQL

Exercise :: 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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

13. 

A subquery in an SQL SELECT statement is enclosed in:

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

14. 

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

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

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.