SQL FOR DATABASE CONSTRUCTION QUIZ

CREATE TABLE

ALTER TABLE

DEFINE TABLE

MAKE TABLE

trigger

None of these

embedded SELECT statement

pseudofile

to prevent the display of sensitive data only.

to accomplish both of the above.

None of these

to simplify a result only.

False

True

False

True

is not an SQL statement.

works whether or not referential integrity constraints would be violated.

deletes the table structure only.

deletes the table structure along with the table data.

To hide rows only

To hide columns only

To hide complicated SQL statements only

All of these

False

True

True

False

CREATE VIEW

SELECT VIEW

INSERT VIEW

MAKE VIEW