Without using database checkpoints, how you test a sql query in qtp?



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

Post New Answer

More Database Testing Interview Questions

What are the steps need to be taken while testing stored procedures?

1 Answers  


How to test a dts package created for data insert update and delete?

1 Answers  


What is performance testing and the bottlenecks of it?

1 Answers  


What is the way of writing testcases for database testing?

1 Answers  


After entering the data from the front-end application interface, how do you test whether a database is updated or not?

1 Answers  


What does the rdbms stand for and what are the major rdbms used by sql?

1 Answers  


How to test database in manually? Explain with an example?

1 Answers  


What is the meaning of record in a database?

1 Answers  


Does qtp support sql queries, how to use sql queries in qtp?

1 Answers  


What is difference between having clause and where clause?

1 Answers  


How to use sql queries in winrunner/qtp?

1 Answers  


How to test data loading in data base testing?

1 Answers  


Categories