DATABASE REDESIGN QUIZ

True

False

All of these

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

create a complete backup of the operational database only.

test any changes on a test database only.

False

True

Three

Four

One

Two

Correlated subqueries only

None of these

EXISTS/NOT EXISTS expressions only

Both of the above are helpful

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

None of these

data model.

dependency graph.

graphical display.

True

False