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 cascade. 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

Since the delete rule is cascade, deleting a record in relation A will trigger the deletion of all related records in relation B. Therefore, option A is incorrect. Option B is incorrect since the foreign key values in relation B cannot be set to null if the record they refer to in relation A is deleted. Option D is incorrect since only related records in relation B will be deleted, not the entire relation. Option E is incorrect since the delete rule is cascade, meaning that records will be deleted.

The Following Scenario Applies to the Next Several Questions