SQL - Computer Questions and Answers

Read Mode

(Q1) 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.

(Q2) Computer » SQL

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

A

DDL

B

DML

C

HTML

D

XML

(Q3) 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.

(Q4) Computer » SQL

The Microsoft Access wildcards are ____ and ____ .

A

asterisk (*); percent sign (%)

B

percent sign (%); underscore (_)

C

underscore(_); question mark (?)

D

question mark (?); asterisk (*)

(Q5) 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');

(Q6) Computer » SQL

Which one of the following sorts rows in SQL?

A

SORT BY

B

ALIGN BY

C

ORDER BY

D

GROUP BY

(Q7) 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.

(Q8) 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.

(Q9) 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.

(Q10) 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.