Database Testing Question:
Download Questions PDF

How to test a SQL Query in Winrunner? without using DataBase CheckPoints?

Answer:

By writing scripting procedure in the TCL we can connect to the database and we can test data base and queries.
The exact proccess should be:
1)connect to the database
db_connect("query1",DRIVER={drivername};SERVER=server_name;
UID=uidname;PWD=password;DBQ=database_name ");
2)Execute the query
db_excecute_query("query1","write query u want to execute");
-Condition to be mentioned-

3)disconnect the connection
db_disconnect("query");

Download Database Testing Interview Questions And Answers PDF

Previous QuestionNext Question
Is a A fast database retrieval rate a testable requirement?How do you test whether the database is updated as and when an information are added in the front end?Give me an example?