DATABASE REDESIGN QUIZ

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

both of these two conditions are met.

neither of these two conditions is met.

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

test any changes on a test database only.

All of these

create a complete backup of the operational database only.

False

True

database is well-designed.

database is structured.

database has no data.

database is relatively small.

True

False

all rows in the subquery fail the condition only.

neither of these two conditions is met.

both of these two conditions are met.

any row in the subquery meets the condition only.

optimistic

ambivalent

skeptical

None of these

ALTER TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

graphical display.

data model.

None of these

dependency graph.

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName