Computer Questions and Answers

Read Mode

(Q1) Computer » SQL

Which one of the following sorts rows in SQL?

A

SORT BY

B

ALIGN BY

C

ORDER BY

D

GROUP BY

(Q2) Computer » SQL

To sort the results of a query use:

A

SORT BY.

B

GROUP BY.

C

ORDER BY.

D

None of the above is correct.

(Q3) Computer » SQL

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.

(Q4) Computer » SQL

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.

(Q5) Computer » SQL

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.