DATABASE REDESIGN QUIZ

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

None of these

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

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

True

False

True

False

is impossible to do, so a new database must be constructed and the data moved into it.

a database design task that never occurs.

a rare database design task, but does occur.

a common database design task.

by nesting.

None of these

from the top down.

from the bottom up.

database is relatively small.

database is structured.

database has no data.

database is well-designed.

True

False

True

False

ambivalent

None of these

optimistic

skeptical

NOT EXISTS

EXISTS

Double use of NOT EXISTS

None of these