Data base testing for Testers

5). How to test a SQL Query in WinRunner? With out using Database Checkpoints?

  By writing scripting procedure in the TCL we can connect to the database and we can test database and      queries.

6). How does you test whether a database in updated when information is entered in the front end?

With database check point only in Win Runner, but in manual we will go to front end using some information. Will get some session names using that session names we search in back end. If that information is correct then we will see query results.

7). What are the different stages involved in Database Testing?

In Database 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.

8). What SQL statements have you used in Database Testing?

DDLDDL is Data Definition Language statements. Some examples: · CREATE · ALTER - · DROP -· TRUNCATE -· COMMENT - · RENAME - DMLDML is Data Manipulation Language statements. Some examples: · SELECT - · INSERT - · UPDATE - · DELETE - · MERGE - UPSERT -· CALL - · EXPLAIN PLAN - · LOCK TABLE - DCLDCL is Data Control Language statements. Some examples: · GRANT - · REVOKE - · COMMIT - · SAVEPOINT - · ROLLBACK - COMMIT -· SET TRANSACTION - This are the Database testing commands.

9). How to use SQL queries in WinRunner/QTP?

In QTP

Using output database check point and database check point,

Select SQL manual queries option 

And enter the "select" queries to retrieve data in the database and compare 

The expected and actual.

10). What steps does a tester take in testing Stored Procedures?

 In my view, the tester has to go through the requirement, as to why the particular stored procedure is written for? And 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 comments, updated by, etc.