DATABASE REDESIGN QUIZ

True

False

False

True

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

create a complete backup of the operational database only.

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

All of these

test any changes on a test database only.

False

True

False

True

ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

None of these

Changing a column data type from char to date

Neither of the above actions will succeed

Both of the above actions should succeed

Changing a column data type from numeric to char

False

True

True

False