Database Testing Processes - Database Testing

What is Database Testing – Processes?

The process used to perform database testing is same as testing of other applications. DB testing is described with the key processes mentioned below.

  • Set up the environment
  • Run a test
  • Check the test result
  • Validate according to the expected results
  • Report the findings to the respective stakeholders

Test cases can be developed by various SQL statements. The most commonly used SQL statement that is used to perform Database testing, is the Select statement. Apart from Select statement, various DDL, DML, DCL statements are also used.

Example − Create, Select, Insert, Update, etc.

What are Database Testing Stages?

The process of DB testing is not a tedious process and includes different stages in lifecycle of database testing in accordance with the test processes.

The important stages of database testing are −

  • Initial state checking
  • Test run
  • Outcome validation as per expected result
  • Generating the results

First stage in Database testing is to verify the initial state of the database before the testing process is started. Then database behavior can be tested for the test cases defined. In accordance with obtained results, test cases are customized.

For database testing to be successful, the below workflow is executed by each and every single test.

  • Cleaning up the database − The testable data in the database should be emptied if any exists.
  • Set up Fixture − This is used to enter the data into database and verifies the current state of the database.
  • Perform test, verify results and generate results − Run the Test and the output is verified. If the output is same as expected result, the next step is to generate the results as per requirement. Otherwise, testing is repeated to find the bugs in database.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Database Testing Topics