DATABASE REDESIGN QUIZ

True

False

database is structured.

database is well-designed.

database has no data.

database is relatively small.

False

True

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

from the top down.

from the bottom up.

None of these

by nesting.

any row in the subquery meets the condition only.

all rows in the subquery fail the condition only.

both of these two conditions are met.

neither of these two conditions is met.

True

False

All of these

drop the foreign key constraint.

drop the table containing the foreign key.

drop the primary key.

Both of the above actions should succeed

Changing a column data type from char to date

Changing a column data type from numeric to char

Neither of the above actions will succeed

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName