What type of testing will confirm that a database schema meets organizational requirements?

• A. Performance testing
• B. Integrity testing
• C. Security testing
• D. End-to-end testing

Answer: (B)

Integrity testing is focused on confirming that a database schema adheres to the defined rules and constraints that ensure data accuracy and consistency within the database. This type of testing validates that relationships among data elements are maintained properly and that constraints, such as primary keys, foreign keys, and unique constraints, are enforced as intended.

When integrity testing is conducted, the schema is checked to ensure it meets organizational requirements regarding data structure and relationships. This is crucial for maintaining the reliability of the data stored and for supporting the integrity of business processes that depend on that data.

Performance testing, on the other hand, evaluates how well a database performs under expected workload conditions but does not specifically address whether the schema meets business requirements. Security testing is aimed at identifying vulnerabilities and ensuring protection against unauthorized access, while end-to-end testing focuses on the entire application process flow, which includes interactions with the database but does not specifically validate the schema’s adherence to organizational data requirements.