What are the different stages involved in Database Testing?

Replies to This Discussion

Permalink Reply by Shakthi on December 17, 2008 at 4:34pm

Shweta,

Verify whether the front end values are correctly storing in the back end database by writing the sql queries.

Verify the Constraints (Primary key,foreign key, Composite key)

Check the performance of the Stored Procedure

Check for the execution of the Triggers

The field size validation

Check constraints

Indexes are done or not (for performance related issues)

• ▶ Reply

Permalink Reply by Gowtham on December 17, 2008 at 4:35pm

Hi Shweta,

The different stages involved in Data Base testing are

1)Verify the data in the database w.r.t front end transactions

2)Verify the constraint (primary key,foreign key ....)

3)Verify the performance of the procedures

4)Verify the triggers (execution of triggers)

5)Verify the transactions (begin,commit,rollback)

6) The field size validation

7)Stored procedures

8)The field size defined in the application is matching with that in the db.


Regards
Gowtham

• ▶ Reply

Permalink Reply by Sami@Testing on December 17, 2008 at 10:26pm

The stages to perform Database Testing are :
a) Connection Establishment by specifying the database provider depends on the type of database.
b) Test Query Processing.
c) Test Query Result.
d) Database Test Report.
e) Database Test Review.
f) Database Test Report Submission.
g) DB test Resolution.
h) DB Regression Test.
i) DB test closure.

If any thing wrong correct me..................

• ▶ Reply

Permalink Reply by vishnu chaudary on December 24, 2009 at 10:30am

Indeed a nice way to explain knowledge about database testing.

• ▶ Reply