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

Correct Answer:  C. ORDER BY

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.

Correct Answer:  C. ORDER BY

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.

Correct Answer:  A. use FROM to name the source table(s) and list the columns to be shown after SELECT.

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.

Correct Answer:  D. All of the above can be done by SQL.

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.

Correct Answer:  A. SELECT

Leave A Comment?

three × three =