DATABASE REDESIGN QUIZ

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

a rare database design task, but does occur.

a database design task that never occurs.

a common database design task.

True

False

True

False

False

True

True

False

skeptical

optimistic

ambivalent

None of these

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

False

True

The processing of the SELECT statements is nested.

They are very similar to a regular subquery.

EXISTS/NOT EXISTS is a form of a correlated subquery.

They can be used to verify functional dependencies.

True

False