DATABASE REDESIGN QUIZ

Changing a column data type from char to date

Both of the above actions should succeed

Changing a column data type from numeric to char

Neither of the above actions will succeed

neither of these two conditions is met.

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

both of these two conditions are met.

False

True

True

False

False

True

test any changes on a test database only.

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

create a complete backup of the operational database only.

All of these

None of these

ALTER TABLE

RENAME TABLE

CHANGE TABLE

True

False

EXISTS/NOT EXISTS expressions only

None of these

Correlated subqueries only

Both of the above are helpful

ALTER TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName