How to test a SQL Query in Winrunner? without using DataBase CheckPoints?
Submitted by: AdministratorBy 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");
Submitted by: Administrator
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");
Submitted by: Administrator
Read Online Database Testing Job Interview Questions And Answers
Top Database Testing Questions
☺ | How to Test database in Manually? Explain with an example? |
☺ | What we normally check for the Database Testing? |
☺ | What steps does a tester take in testing Stored Procedures? |
☺ | Is a A fast database retrieval rate a testable requirement? |
Top Testing Categories
☺ | Manual Testing Interview Questions. |
☺ | Rational TestSuite Interview Questions. |
☺ | QTP Interview Questions. |
☺ | Database Testing Interview Questions. |
☺ | Software QA Interview Questions. |