The Following Scenario Applies to the Next Several Questions

question 20

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

---

Definitions:

Face Value

The nominal value printed on a bond or share, representing its legal value rather than market value.

Bond Discount

The difference when bonds are sold for less than their face value, indicating investors require a higher yield due to perceived risks or interest rates being higher than the bond's rate.

Accrued Interest

Interest that has been incurred but not yet paid, often relating to bonds or loans.

Semiannual Interest Expense

Interest expense that is due or accrued every six months on outstanding debts.