SQL FOR DATABASE CONSTRUCTION QUIZ

True

False

True

False

Lists of values

Comparing one column value to another within the same table

System date

Range checks

To accomplish both of the above.

None of these

To ensure that the results are consistent.

To save users from having to write an expression.

MAKE VIEW

CREATE VIEW

SELECT VIEW

INSERT VIEW

to prevent the display of sensitive data only.

to accomplish both of the above.

to simplify a result only.

None of these

None of these

stored procedure

pseudofile

trigger

WHERE

GROUP BY

FROM

ORDER BY

True

False

change the table structure.

delete rows from the table.

add rows to the table.

change the table data.