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