The following scenario applies to the next several questions:
Consider relations A and B. Relation A represents the entity on the "one side" of a one-to-many relationship; Relation B represents the entity on the "many side" of the one-to-many relationship.
-The delete rule between relations A and B is restrict. If an attempt is made to delete a record in relation B ____.
A) the record in relation B will be the only record deleted and no other changes will occur
B) the record in relation B will be the only record deleted and any matching field values in relation A will be updated to null
C) the record in relation B and all of the records in relation A with field values that match the primary key value of the record in relation B will be deleted
D) only the records in relation A with field values that match the primary key value of the record in relation B will be deleted
E) no records will be deleted

Question

Quizplus · Accepted Answer

The "restrict" delete rule prevents deletion in the "one side" relation if there are matching records in the "many side" relation. However, deleting a record in the "many side" (relation B) does not violate this rule, so the record in relation B can be deleted without affecting relation A.

The Following Scenario Applies to the Next Several Questions