DATABASE REDESIGN QUIZ

MODIFY TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

False

True

Neither of the above actions will succeed

Changing a column data type from numeric to char

Both of the above actions should succeed

Changing a column data type from char to date

False

True

None of these

an internal model.

a conceptual model.

a logical model.

False

True

True

False

a common database design task.

a database design task that never occurs.

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

a rare database design task, but does occur.

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

True

False