What is data integrity in DB2?
- Ensuring accuracy of data
- Ensuring consistency of data
- Ensuring availability of data
- Ensuring security of data
Data integrity in DB2 refers to maintaining the accuracy and consistency of data stored in the database. It ensures that data remains valid, reliable, and consistent throughout its lifecycle. This includes enforcing rules and constraints to prevent invalid data entry or modification, such as ensuring referential integrity and maintaining data consistency across multiple tables. Therefore, the correct option is to ensure the consistency of data.
Loading...
Related Quiz
- In DB2, a view allows users to ________ data from one or more tables.
- How can denormalization lead to potential data inconsistency issues?
- Scenario: A DBA notices a sudden increase in database response time. What steps should they take to troubleshoot this issue effectively?
- Which utility is commonly used for database backup and recovery tasks in DB2?
- The Log Manager component of DB2's architecture facilitates ________.