SQL FOR DATABASE CONSTRUCTION QUIZ

SELECT VIEW

MAKE VIEW

CREATE VIEW

INSERT VIEW

None of these

The CHECK constraint

The LIMIT constraint

The VALUE constraint

pseudofile

None of these

embedded SELECT statement

trigger

is not an SQL statement.

deletes the table structure along with the table data.

deletes the table structure only.

works whether or not referential integrity constraints would be violated.

False

True

CREATE TABLE

DEFINE TABLE

MAKE TABLE

ALTER TABLE

a particular column in a particular underlying table.

a particular column in a particular row.

a particular row in a particular underlying table.

None of these

False

True

AFTER

INSTEAD OF

BEFORE

All of these

False

True