Database - Introduction to SQL
Exercise :: Introduction to SQL - General Questions
| 26. |
Which one of the following sorts rows in SQL? |
| A. |
SORT BY | | B. |
ALIGN BY | | C. |
ORDER BY | | D. |
GROUP BY |
Answer: Option C
Explanation:
|
| 27. |
To sort the results of a query use: |
| A. |
SORT BY. | | B. |
GROUP BY. | | C. |
ORDER BY. | | D. |
None of the above is correct. |
Answer: Option C
Explanation:
|
| 28. |
To define what columns should be displayed in an SQL SELECT statement: |
| A. |
use FROM to name the source table(s) and list the columns to be shown after SELECT. | | B. |
use USING to name the source table(s) and list the columns to be shown after SELECT. | | C. |
use SELECT to name the source table(s) and list the columns to be shown after USING. | | D. |
use USING to name the source table(s) and list the columns to be shown after WHERE. |
Answer: Option A
Explanation:
|
| 29. |
SQL can be used to: |
| A. |
create database structures only. | | B. |
query database data only. | | C. |
modify database data only. | | D. |
All of the above can be done by SQL. |
Answer: Option D
Explanation:
|
| 30. |
The SQL statement that queries or reads data from a table is ________ . |
| A. |
SELECT | | B. |
READ | | C. |
QUERY | | D. |
None of the above is correct. |
Answer: Option A
Explanation:
|
