DATABASE REDESIGN QUIZ

Four

One

Three

Two

neither of these two conditions is met.

both of these two conditions are met.

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

False

True

database is relatively small.

database has no data.

database is structured.

database is well-designed.

False

True

graphical display.

None of these

data model.

dependency graph.

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

All of these

test any changes on a test database only.

create a complete backup of the operational database only.

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

ambivalent

optimistic

None of these

skeptical

True

False