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.
Loading...
Related Quiz
- In DB2, what does the MIN() function return?
- How does a materialized view differ from a regular view in DB2?
- Which SQL command is used to modify existing records in a table?
- The EXISTS keyword in DB2 is commonly used in conjunction with ________ to test for the existence of rows in a subquery result.
- How does the performance of a subquery differ from that of a join in DB2?