how do you do database testing in qtp

Answers were Sorted based on User's Feedback



how do you do database testing in qtp..

Answer / aryan

we use database checkpoints to do database testing in qtp.
database checkpoints in a test ensure that the application
successfully retrieves or inserts data into a database.

Is This Answer Correct ?    16 Yes 2 No

how do you do database testing in qtp..

Answer / nani4urs

Wn we have to do database testing in qtp
first we need to create ODBC Connection using DSN.
then we need to write some commands.

Is This Answer Correct ?    12 Yes 2 No

how do you do database testing in qtp..

Answer / rajiv.m

In QTP, Database testing is done by inserting Database
Checkpoint. Here we can check database available in any
format like Excel, Access, SQL.... First we need to create
ODBC Connection using DSN and then we need to write some
commands. Here are some commands which are useful for
database testing. <a
href="http://www.1keydata.com/sql/sql-commands.html">SQL
Commands</a>

Is This Answer Correct ?    8 Yes 3 No

how do you do database testing in qtp..

Answer / baba

Database Testing means checking the Database informations
is available in the customer requirement or not.
Some cases DB administrators might replaces the columns or
changes some information inthe database.

Database Checkpoints is used to Test Databases.
Here we can check database available in any format like
EXcel, Access, SQL.... QTP will provide you a drivers to
connect with that and download the Data from DB. You should
be the some what familiar with the SQL Queries.

Is This Answer Correct ?    7 Yes 3 No

how do you do database testing in qtp..

Answer / fayaz khan

While DataBase Testing time first we get the "Data Base Design information" From developers,Here we get the information like

->Names Of the table and there columns names
->Connection Strings(DNS)
->Mapping b/w screens & Tables..

After that we connect to the Database through ADODB.And retrive the data for testing

Adodb is a vb script object to connect to database..


Anybody want to more information about database testing through QTP Please leave a mail to me ....fayazkhan505@gmail.com..

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More QTP Interview Questions

Hi anyone having QTP 10.0 licence or crack version pls send me in this mail id mdilipkumar04@gmail.com Regards Dilip

1 Answers  


Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........

0 Answers  


Hello Everyone, I have a problem. QTP is capturing no action on a particular page in the application that I am trying to automate. But on the same side its working fine on other pages of the same application. Can someone please help me understand the reason behind this inconsistency.

1 Answers  


what is the test process followed for your project?

1 Answers   ADP, Satyam,


actually how many hours per one day we will work on automation (qtp) in real time

1 Answers   Synechron,


What is the difference between Client/Server application and Web application ?

2 Answers   ArisGlobal,


How many function you use in your application?

2 Answers   Polaris,


Using Regular expression method some particular value is not present in given value. HOow do use regular expression? Forexample password all number,character ,special character are accepted but (_',)underscore,comma are not used. How do write regular expression.

1 Answers  


I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...

0 Answers  


Now it appears to be more than enough... I have learn entire QTP, I did whatever I could do but still facing lots of problem and those problems could be removed only after working in professional atmosphere. But still unable to expose myself as professionaly. It is becoming panic, It has been two years I am in manual testing and looking for the change but all the recruiters ask for QTP, but my problem is I don't have working experience with QTP. Kindly suggest me I really need effective suggestions. I dont have more caliber to work with present organization cause of salary reasons...boo.. hooo...hooo. My email address is alkaa.dugaal@gmail.com

0 Answers  


What is use of object spy?

0 Answers  


What is a reusable action?

0 Answers  


Categories