DATABASE REDESIGN QUIZ

All of these

clearly understand the current structure and contents of the database only.

test any changes on a test database only.

create a complete backup of the operational database only.

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

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

None of these

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

True

False

The processing of the SELECT statements is nested.

EXISTS/NOT EXISTS is a form of a correlated subquery.

They can be used to verify functional dependencies.

They are very similar to a regular subquery.

RENAME TABLE

ALTER TABLE

CHANGE TABLE

None of these

False

True

optimistic

None of these

ambivalent

skeptical

One

Two

Three

Four

False

True

MODIFY TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName