DATABASE REDESIGN QUIZ

Both of the above actions should succeed

Neither of the above actions will succeed

Changing a column data type from numeric to char

Changing a column data type from char to date

None of these

from the top down.

from the bottom up.

by nesting.

False

True

True

False

False

True

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

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

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

None of these

Three

One

Four

Two

False

True

CHANGE TABLE

ALTER TABLE

None of these

RENAME TABLE

False

True