DATABASE REDESIGN QUIZ

All of these

test any changes on a test database only.

create a complete backup of the operational database only.

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

False

True

False

True

True

False

None of these

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

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

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

False

True

both of these two conditions are met.

neither of these two conditions is met.

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

False

True

False

True

False

True