SQL FOR DATABASE CONSTRUCTION QUIZ

False

True

change the table structure.

change the table data.

delete rows from the table.

add rows to the table.

pseudofile

trigger

None of these

stored procedure

ORDER BY

FROM

GROUP BY

WHERE

True

False

None of these

embedded SELECT statement

pseudofile

trigger

Just another table

A relation

Query results

A view

INSERT VIEW

CREATE VIEW

MAKE VIEW

SELECT VIEW

False

True

To ensure that the results are consistent.

None of these

To save users from having to write an expression.

To accomplish both of the above.