Home > Software > Testing > Manual-Testing
Interview Questions   Tutorials   Discussions   Programs   Videos   

Manual-Testing - What is data base testing? explain with example

asked marvit October 12, 2014 12:30 AM  

What is data base testing? explain with example


1 Answers

answered By cipher   0  

We need to test the following aspects of database first :

1.Data Mapping: In the software systems, data often travels back and forth from the UI (user interface) to the backend DB and vice versa

2.ACID properties validation: atomicity, consistency, isolation and durability. Every transaction a DB performs has to adhere to these four properties.

3.Data integrity:This means that following any of the CRUD operations, the updated and most recent values/Status of shared data should appear on all the forms and screens.

4.Business rule conformity: More complex databases means more complicated components like relational constraints, triggers, stored procedures, etc. So testers will have to come up with appropriate SQL queries in order to validate these complex objects.

Procedure :

1) Prepare the environment

2) Run a test

3) Check test result

4) Validate according to the expected results

5) Report the findings to the respective stakeholders

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!