Which DB2 feature helps to enforce data integrity by automatically updating related data?

  • Cursors
  • Referential Integrity
  • Triggers
  • Views
Referential integrity is the DB2 feature that helps to enforce data integrity by automatically updating related data. When a foreign key in one table references a primary key in another table, referential integrity ensures that the relationships between the tables are maintained. This means that if a record in the parent table is deleted or updated, the corresponding records in the child table are also updated or deleted to maintain consistency. By automatically updating related data, referential integrity helps prevent orphan records and ensures that the data remains accurate and consistent throughout the database. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *