SQL - Computer Questions and Answers

Attempt Mode

Computer » SQL

Which of the following do you need to consider when you make a table in SQL?

A

Data types

B

Primary keys

C

Default values

D

All of the above.

Computer » SQL

SQL query and modification commands make up a(n) ________ .

A

DDL

B

DML

C

HTML

D

XML

Computer » SQL

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

A

LIKE only.

B

IN only.

C

NOT IN only.

D

Both IN and NOT IN.

Computer » SQL

The Microsoft Access wildcards are ____ and ____ .

A

asterisk (*); percent sign (%)

B

percent sign (%); underscore (_)

C

underscore(_); question mark (?)

D

question mark (?); asterisk (*)

Computer » SQL

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

A

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

B

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

C

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

D

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Computer » SQL

Which one of the following sorts rows in SQL?

A

SORT BY

B

ALIGN BY

C

ORDER BY

D

GROUP BY

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.

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.

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.

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.