Database - Introduction to SQL
Exercise :: Introduction to SQL - True or False
16. |
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. |
Answer: Option B
Explanation:
|
17. |
The result of every SQL query is a table. |
Answer: Option A
Explanation:
|
18. |
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. |
Answer: Option A
Explanation:
|
19. |
SUM, AVG, MIN, and MAX can only be used with numeric columns. |
Answer: Option B
Explanation:
|
20. |
Most companies keep at least two versions of any database they are using. |
Answer: Option A
Explanation:
|