CONCRETE TECHNOLOGY AND DESIGN OF CONCRETE STRUCTURES QUIZ

drop the foreign key constraint.

drop the primary key.

drop the table containing the foreign key.

All of these

a logical model.

an internal model.

a conceptual model.

None of these

neither of these two conditions is met.

both of these two conditions are met.

any row in the subquery meets the condition.

all rows in the subquery fail the condition.

True

False

False

True

None of these

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

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

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

True

False

a database design task that never occurs.

a rare database design task, but does occur.

a common database design task.

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

NOT EXISTS

Double use of NOT EXISTS

None of these

EXISTS

True

False