SQL FOR DATABASE CONSTRUCTION QUIZ

System date

Lists of values

Comparing one column value to another within the same table

Range checks

False

True

deletes the table structure along with the table data.

is not an SQL statement.

deletes the table structure only.

works whether or not referential integrity constraints would be violated.

INSTEAD OF

AFTER

BEFORE

All of these

SQL can be optimized

Increased network traffic

Greater security

Code sharing

False

True

CREATE VIEW

SELECT VIEW

MAKE VIEW

INSERT VIEW

False

True

None of these

embedded SELECT statement

trigger

pseudofile

To hide rows only

To hide columns only

To hide complicated SQL statements only

All of these