DATABASE REDESIGN QUIZ

False

True

a logical model.

an internal model.

a conceptual model.

None of these

True

False

drop the table containing the foreign key.

drop the primary key.

drop the foreign key constraint.

All of these

MODIFY TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

RENAME TABLE

None of these

ALTER TABLE

CHANGE TABLE

True

False

False

True

True

False