The Following Scenario Applies to the Next Several Questions

question 28

Multiple Choice

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

---

Definitions:

Compensating Differential

Additional payment or benefit given to an employee to offset or compensate for undesirable aspects of a job.

Base Pay

The initial rate of compensation that an employee receives before any bonuses, benefits, or raises are added.

Skill

The ability, coming from one's knowledge, practice, aptitude, etc., to do something well.

Prestigious

Associated with high status, esteem, or importance.