Without using database checkpoints, how you test a sql query in qtp?
Answer / Prashant Kumar Chaturvedi
To test SQL queries without using database checkpoints in QTP (QuickTest Professional), you can follow these steps:
1. Record the SQL queries against the database.
2. Use functions like DBMSEval or DBSql to execute the queries and retrieve results.
3. Verify the results returned by comparing them with expected results, using built-in functions such as Test.Assert or Test.Expect.
4. Repeat these steps for each test case.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the steps need to be taken while testing stored procedures?
How to test a dts package created for data insert update and delete?
What is performance testing and the bottlenecks of it?
What is the way of writing testcases for database testing?
After entering the data from the front-end application interface, how do you test whether a database is updated or not?
What does the rdbms stand for and what are the major rdbms used by sql?
How to test database in manually? Explain with an example?
What is the meaning of record in a database?
Does qtp support sql queries, how to use sql queries in qtp?
What is difference between having clause and where clause?
How to use sql queries in winrunner/qtp?
How to test data loading in data base testing?