DATABASE REDESIGN QUIZ

False

True

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

drop the primary key.

drop the foreign key constraint.

All of these

drop the table containing the foreign key.

True

False

All of these

test any changes on a test database only.

clearly understand the current structure and contents of the database only.

create a complete backup of the operational database only.

False

True

False

True

False

True

False

True

all rows in the subquery fail the condition.

any row in the subquery meets the condition.

neither of these two conditions is met.

both of these two conditions are met.