How can you test an SQL Query in WinRunner?

Database Testing - Interview Questions

Step 1 : Connect to the database :

db_connect(query1 DRIVER {drivername};SERVER server_name;UID uidname;
PWD password;DBQ database_name );

Step 2 : Execute the query of the database :

db_excecute_query (write the required query that is to execute); Specify the appropriate condition

Step 3 : Disconnect the database connection by using :

db_disconnect(query);

Using Output database checkpoints, SQL manual queries options must be selected. Here, the select query can be written.