DATABASE REDESIGN QUIZ

True

False

None of these

database design.

data modeling.

reverse engineering.

True

False

drop the primary key.

drop the table containing the foreign key.

All of these

drop the foreign key constraint.

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

False

True

Correlated subqueries only

Both of the above are helpful

None of these

EXISTS/NOT EXISTS expressions only

False

True

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

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

None of these

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

False

True