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