SQL FOR DATABASE CONSTRUCTION QUIZ

To save users from having to write an expression.

None of these

To accomplish both of the above.

To ensure that the results are consistent.

True

False

False

True

True

False

pseudofile

embedded SELECT statement

trigger

None of these

Increased network traffic

SQL can be optimized

Greater security

Code sharing

a particular row in a particular underlying table.

None of these

a particular column in a particular underlying table.

a particular column in a particular row.

MAKE TABLE

CREATE TABLE

ALTER TABLE

DEFINE TABLE

False

True

ALTERNATE KEY

UNIQUE

FOREIGN KEY

PRIMARY KEY