What are the different stages involved in Database Testing?

Replies to This Discussion

Permalink Reply by Gowtham on January 16, 2009 at 11:52am

Hi Barghavi,

There are different stages for Data Base testing..

1) Verify field level data in the database with respect to frontend transactions
2) Verify the constraint (primary key,forien key ....)
3) Verify the performance of the procedures
4) Verify the triggrs (execution of triggers)
5) Verify the transactions (begin,commit,rollback)..

Regards
Gowtham

• ▶ Reply

Permalink Reply by Praveen singh on June 13, 2016 at 10:01am

Hi,

You can find more details of database testing by clicking here

Thanks,

Praveen

• ▶ Reply

Permalink Reply by Jack Ramon on March 9, 2018 at 6:38pm

Database testing is a kind of software testing where you make sure that what you enter on web forms that information is being saved in to basked database as expected. Data constraints are maintained while doing migration or up-gradation of your web application. You meta data gets intact. CRUD operations are working as required.

In DB testing we need to check for,
1. The field size validation
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures
5. The field size defined in the application is matching with that in the db.

• ▶ Reply

Permalink Reply by Alise Williams on October 5, 2018 at 8:51pm

Every software testing company has its own streamlined testing process, in particular in database testing. First, they analyze the project, then provide an estimation and testing plan. Project execution phase contains many stages, like testing, creating bug reports and giving recommendations for the next phases. To learn about software QA process in details, you can look out websites of software companies and learn their experience. 

• ▶ Reply

Permalink Reply by Anand Singh on November 29, 2018 at 3:20pm

Hi Barghavi

As per functional testing services database testing is type of testing which involves verifying tables, writing SQL queries and procedures. Testing is to be performed on desktop or web application and database(SQL or Oracle) used in the application. Below are the stages of database testing:

1. Ensure that correct data get inserted in the database
2. Test the DB table constraints such as primary and foreign keys
3. Test the procedure performance
4. Test the transactions such as begin, commit, rollback, etc.
5. Test the execution of triggers by executing them

Regards

Anand Singh

• ▶ Reply