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 questionsThe 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.
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.
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.
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).
Keep practicing
Take the free ASSOCIATE-REACTIVE-DEVELOPER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ASSOCIATE-REACTIVE-DEVELOPER practice questions
- Question 1When the event is mandatory, a Block event such as the Client Action must be specified to…
- Question 2Considering the Function property in Client Actions, which of the following options is co…
- Question 3Which event is needed if we do some logic over the result such as checking if it is empty?
- Question 4The SQL Query only allows executing SELECT statements
- Question 5The order of the Entities in the join does not matter.
- Question 6The list of values displayed on the Combo Box widget can be a combination of Entity and S…
