The Following Scenario Applies to the Next Several Questions

question 13

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

---

Definitions:

Impliedly Authorized

Actions or decisions that are not explicitly stated but are inferred as permitted within the scope of someone's authority.

Bankruptcy Petition

A formal request filed in court by an individual or business declaring inability to pay outstanding debts, seeking relief under bankruptcy laws.

Attorney-Client Privilege

A legal principle that protects communications between attorneys and their clients as confidential.

Client Confidentiality Rule

A principle that obligates lawyers, and certain other professionals, to keep information relating to their clients secret, unless the client gives consent to disclose such information.