DATABASE REDESIGN QUIZ

both of these two conditions are met.

neither of these two conditions is met.

any row in the subquery meets the condition only.

all rows in the subquery fail the condition only.

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD ColumnName

a common database design task.

a rare database design task, but does occur.

a database design task that never occurs.

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

True

False

True

False

data model.

graphical display.

dependency graph.

None of these

False

True

neither of these two conditions is met.

both of these two conditions are met.

all rows in the subquery fail the condition.

any row in the subquery meets the condition.

False

True

True

False