DATABASE REDESIGN QUIZ

database has no data.

database is structured.

database is relatively small.

database is well-designed.

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);

all rows in the subquery fail the condition only.

neither of these two conditions is met.

any row in the subquery meets the condition only.

both of these two conditions are met.

graphical display.

None of these

data model.

dependency graph.

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD ColumnName

None of these

NOT EXISTS

EXISTS

Double use of NOT EXISTS

a rare database design task, but does occur.

a database design task that never occurs.

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

a common database design task.

True

False

True

False

True

False