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.
Loading...
Related Quiz
- User-defined functions in DB2 can encapsulate ________ logic for reuse in queries.
- In a RIGHT JOIN operation, which table's data is retained even if there are no matching rows in the other table?
- Which type of constraint in DB2 ensures data integrity by enforcing uniqueness?
- Which type of compression in DB2 reduces the size of data by eliminating redundant information?
- A deadlock in DB2 occurs when ________ transactions are waiting for each other to release locks.