SQL FOR DATABASE CONSTRUCTION QUIZ

None of these

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

columns and rows only.

complicated SQL syntax only.

change the table data.

add rows to the table.

change the table structure.

delete rows from the table.

None of these

To save users from having to write an expression.

To ensure that the results are consistent.

To accomplish both of the above.

False

True

MAKE TABLE

CREATE TABLE

DEFINE TABLE

ALTER TABLE

False

True

Greater security

SQL can be optimized

Increased network traffic

Code sharing

deletes the table structure only.

is not an SQL statement.

deletes the table structure along with the table data.

works whether or not referential integrity constraints would be violated.

False

True

All of these

AFTER

INSTEAD OF

BEFORE