You are testing a database that stores customer information. During data integrity testing, you discover that some customer records have duplicate entries with slight variations in data. What type of data integrity issue is this?
- Data Consistency Issue
- Domain Integrity Issue
- Entity Integrity Issue
- Referential Integrity Issue
In this scenario, the issue is related to domain integrity. Domain integrity ensures that all data entered into a specific column meets certain specified criteria, such as data type and range. Duplicate entries with slight variations indicate a lack of control over the allowable values within a column, thus violating the domain integrity constraint. This can lead to inconsistencies in the data stored in the database.
Loading...
Related Quiz
- What is the purpose of database query optimization in performance testing?
- What is the role of a test plan in the database testing process?
- Which best practice is crucial for maintaining data privacy and security during database testing?
- How does handling different database systems (e.g., SQL Server, Oracle) pose a challenge in database testing?
- Which type of tool is commonly used to capture and analyze database performance metrics in real-time?