DATABASE REDESIGN QUIZ

False

True

neither of these two conditions is met.

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

both of these two conditions are met.

None of these

ALTER TABLE

CHANGE TABLE

RENAME TABLE

from the top down.

by nesting.

None of these

from the bottom up.

False

True

Four

Three

One

Two

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

False

True

False

True

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

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

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

None of these