DATABASE REDESIGN QUIZ

False

True

MODIFY TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

True

False

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.

False

True

False

True

Both of the above actions should succeed

Neither of the above actions will succeed

Changing a column data type from char to date

Changing a column data type from numeric to char

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

test any changes on a test database only.

create a complete backup of the operational database only.

All of these

True

False

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

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

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

None of these