SQL FOR DATABASE CONSTRUCTION QUIZ

False

True

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

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

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

rows can be modified according to criteria only.

True

False

MAKE VIEW

SELECT VIEW

CREATE VIEW

INSERT VIEW

trigger

embedded SELECT statement

pseudofile

None of these

deletes the table structure only.

deletes the table structure along with the table data.

works whether or not referential integrity constraints would be violated.

is not an SQL statement.

SQL can be optimized

Code sharing

Greater security

Increased network traffic

All of these

To hide rows only

To hide complicated SQL statements only

To hide columns only

True

False

None of these

complicated SQL syntax only.

columns and rows only.

both of the above can be hidden by an SQL view.