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 set-to-null. If an attempt is made to delete a record in relation A and its primary key value appears as a foreign key value in one or more records of relation B ____.
A) the record in relation A will be the only record deleted and no other changes will occur
B) the record in relation A will be the only record deleted and the foreign key values in relation B that match the primary key value of the record in relation A will be updated to null
C) the record in relation A and all of the records in relation B with foreign key values that match the primary key value of the record in relation A will be deleted
D) only the records in relation B with foreign key values that match the primary key value of the record in relation A will be deleted
E) no records will be deleted

Question

Quizplus · Accepted Answer

The set-to-null delete rule specifies that when a record in the "one side" (relation A) of a one-to-many relationship is deleted, the foreign key values in the "many side" (relation B) that reference the deleted record's primary key will be set to null, rather than deleting any records in relation B.

The Following Scenario Applies to the Next Several Questions