ASSOCIATE-REACTIVE-DEVELOPER practice question 12 of 35

Regarding the Delete Rule property, which of the following options does not guarantee referential integrity?

Full set: 262 questions
Answer options
A: Ignore Correct answer
B: Delete
C: Protect
Correct Answer:
A. Ignore
Explanation

The Ignore delete rule allows a record in the parent entity to be deleted without affecting any related records in the child entity. This action leaves the foreign key attribute in the child entity's records pointing to a non-existent record in the parent entity. This state, known as having "orphan records," explicitly breaks referential integrity because the relationship is no longer valid. In contrast, the Protect and Delete rules are mechanisms designed to actively preserve referential integrity by either preventing the deletion or cascading it to dependent records, respectively.

Why Incorrect

B. Delete: This rule maintains referential integrity. When a parent record is deleted, all associated child records are also automatically deleted (cascading delete), preventing orphan records.
C. Protect: This rule strictly enforces referential integrity by preventing the deletion of a parent record if any child records are referencing it, thus avoiding any data inconsistency.

References

1. OutSystems Official Documentation, "Enforce Referential Integrity":

Section: Delete Rule Property

Content: "With the Ignore rule, when you try to delete a record from the parent Entity, the database does nothing to the related records in the child Entity. The foreign key attribute of the related records will hold a value that no longer exists in the parent Entity." This directly confirms that the Ignore rule leads to a loss of referential integrity.

URL: https://success.outsystems.com/documentation/11/developinganapplication/usedata/datamodeling/entities/enforcereferentialintegrity/

2. OutSystems Guided Path, "Become a Reactive Web Developer":

Course: Modeling Data

Lesson: Entity Relationships

Content: The lesson explains the Delete Rule property. It states: "With the Ignore rule, the record is deleted, but the foreign key in the other entity is not updated. This can lead to inconsistent data." This reinforces that Ignore does not guarantee data integrity.

URL: https://www.outsystems.com/training/paths/18/becoming-a-reactive-web-developer/ (Access to the specific lesson requires login).

Scroll to Top