Entries tagged as Database Testing
What is database testing and what we test in database testing?
An1: Database testing is all about testing joins, views, inports and exports , testing the procedures, checking locks, indexing etc. Its not about testing the data in the database. Usually database testing is performed by DBA. An2: Database testing involves some in depth knowledge of the given application and requires more defined plan of approach Read More...
How to use SQL queries in WinRunner/QTP?
In QTP using output databse check point and database check point , select SQL manual queries option and enter the “select” queris to retrive data in the database and compare the expected and actual. Read More...
What are the different stages involved in Database Testing
verify field level data in the database with respect to frontend transactions verify the constraint (primary key,forien key ….) verify the performance of the procedures verify the triggrs (execution of triggers) verify the transactions (begin,commit,rollback) Read More...
What steps does a tester take in testing Stored Procedures?
First the tester should to go through the requirement, as to why the particular stored procedure is written for. Then check whether all the required indexes, joins, updates, deletions are correct comparing with the tables mentions in the Stored Procedure. And also he has to ensure whether the Stored Procedure follows the standard format like Read More...