DATABASE REDESIGN QUIZ

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 common database design task.

a rare database design task, but does occur.

False

True

None of these

dependency graph.

data model.

graphical display.

database is well-designed.

database is relatively small.

database is structured.

database has no data.

False

True

They are very similar to a regular subquery.

The processing of the SELECT statements is nested.

They can be used to verify functional dependencies.

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

by nesting.

None of these

from the bottom up.

from the top down.

True

False

EXISTS

Double use of NOT EXISTS

NOT EXISTS

None of these

MODIFY TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName