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:
|
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:
|
13. |
A subquery in an SQL SELECT statement is enclosed in: |
A. |
braces -- {...}. | B. |
CAPITAL LETTERS. | C. |
parenthesis -- (...) . | D. |
brackets -- [...]. |
Answer: Option C
Explanation:
|
14. |
The result of a SQL SELECT statement is a(n) ________ . |
Answer: Option D
Explanation:
|
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:
|