How does referential integrity ensure data integrity in DB2?

  • By compressing the data
  • By creating indexes
  • By encrypting the data
  • By enforcing relationships between tables
Referential integrity in DB2 ensures data integrity by enforcing relationships between tables. This means that when a foreign key in one table references a primary key in another table, the integrity of the relationship is maintained. For example, 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. This 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 *