DATABASE REDESIGN QUIZ

None of these

Correlated subqueries only

EXISTS/NOT EXISTS expressions only

Both of the above are helpful

a logical model.

a conceptual model.

None of these

an internal model.

True

False

True

False

False

True

ALTER TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

False

True

All of these

drop the primary key.

drop the foreign key constraint.

drop the table containing the foreign key.

a common database design task.

is impossible to do, so a new database must be constructed and the data moved into it.

a database design task that never occurs.

a rare database design task, but does occur.

True

False