What is Database testing?Database testing includes the following process:
1. Data validity testing – To perform this testing, one should be good in SQL queries
2. Data integrity testing - To perform this testing, the referential integrity and constraints should be known.
3. Performance testing in relation with the database - To perform this testing, one should be good in structure of the table and its design.
4. Procedure testing, functions testing and triggers testing – To perform this testing, one should be good enough to understand the program and logic flow.
What is Database testing?Database testing involves testing the behavior of the database when the application is being tested. This may involve testing to see if values are being inserted properly, flags are changing appropriately, validity of data, to ensure if data integrity is maintained. It may also account for performance related to the database. SQL queries can be fired in the database to check if the expected results are achieved.