SQL FOR DATABASE CONSTRUCTION QUIZ

Lists of values

System date

Comparing one column value to another within the same table

Range checks

True

False

Just another table

Query results

A relation

A view

stored procedure

trigger

None of these

pseudofile

True

False

FROM

GROUP BY

WHERE

ORDER BY

Greater security

Code sharing

SQL can be optimized

Increased network traffic

To ensure that the results are consistent.

To save users from having to write an expression.

To accomplish both of the above.

None of these

to prevent the display of sensitive data only.

None of these

to accomplish both of the above.

to simplify a result only.

FOREIGN KEY

UNIQUE

PRIMARY KEY

ALTERNATE KEY