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 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 "restrict" delete rule prevents the deletion of a record in relation A if its primary key value is being referenced as a foreign key in one or more records in relation B. This ensures referential integrity by not allowing the deletion of records that are being referenced.

The Following Scenario Applies to the Next Several Questions