DATABASE REDESIGN QUIZ

database design.

None of these

reverse engineering.

data modeling.

None of these

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

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

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

Changing a column data type from char to date

Changing a column data type from numeric to char

Both of the above actions should succeed

Neither of the above actions will succeed

False

True

True

False

test any changes on a test database only.

All of these

create a complete backup of the operational database only.

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

True

False

both of these two conditions are met.

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.

database has no data.

database is structured.

database is well-designed.

database is relatively small.

an internal model.

a conceptual model.

None of these

a logical model.