DATABASE REDESIGN QUIZ

True

False

True

False

The processing of the SELECT statements is nested.

They can be used to verify functional dependencies.

They are very similar to a regular subquery.

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

True

False

None of these

a logical model.

a conceptual model.

an internal model.

all rows in the subquery fail the condition.

neither of these two conditions is met.

both of these two conditions are met.

any row in the subquery meets the condition.

True

False

False

True

True

False

drop the foreign key constraint.

All of these

drop the table containing the foreign key.

drop the primary key.