SQL FOR DATABASE CONSTRUCTION QUIZ

True

False

True

False

False

True

INSERT VIEW

CREATE VIEW

MAKE VIEW

SELECT VIEW

False

True

rows can either be inserted into a table one at a time or in groups.

rows can be modified according to criteria only.

rows cannot be copied in mass from one table to another only.

rows can be inserted into a table only one at a time only.

None of these

To ensure that the results are consistent.

To accomplish both of the above.

To save users from having to write an expression.

True

False

SQL can be optimized

Increased network traffic

Code sharing

Greater security

False

True