DATABASE REDESIGN QUIZ

True

False

drop the primary key.

drop the table containing the foreign key.

All of these

drop the foreign key constraint.

False

True

False

True

True

False

False

True

True

False

True

False

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.

a database design task that never occurs.

a common database design task.

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);