DATABASE REDESIGN QUIZ

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

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

None of these

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

True

False

RENAME TABLE

CHANGE TABLE

None of these

ALTER TABLE

a rare database design task, but does occur.

a database design task that never occurs.

a common database design task.

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

True

False

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

dependency graph.

graphical display.

None of these

data model.

a conceptual model.

None of these

an internal model.

a logical model.

False

True