how do you do database testing in qtp

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the general steps involved in the data driven framework?

748


• What type of testing questions will be asked for 2+ yrs exp people in interview?

1463


What is a quick test professional?

907


What is the use of text output value in quicktest professional?

695


Explain different types of checkpoints?

761


what are the frame work models of qtp?which frame work you follow in your company?and explain it process?

2223


When you open QTP, how many sheets you can see?

841


How many test scenarios you have automated? How many time it will take to execute 30-40 scenarios? What SDLC model you are following? How often you will execute your test scripts? Because of some changes, your test scripts failed? When you will update your test scripts? How much time it will take to update? Do you know how to connect database? Do you know the direct method to count no. of records (or) rows present in record set once query is executed? How will you create the connection string? How did you resolve conflicts present in Object Repository? How good you are in VB? How will you work on Excel Application? How will you select Excel sheet? If you want to select 10 sheets, will you create 10 separate objects? Given string is “abcd”. What are the methods you will use to display “dcba”? Drives script – explain the frameworks? How you are updating results for each test? What is start up, configuration, navigation scripts? If you are not able to understand the application (some module), who will teach you? What test cases to be automated? When to be automated? What is the testing process you are following? What life cycle you are following? When you will use Descriptive Programming? Do you have the permission to add objects into shared object repository? (OR) someone will maintain SOR? Do you know how to add objects into shared object repository? How many test cases you have automated? How much time will it take to execute? What is complex in automation? When you feel automation is complex? Tell me one scenario, the complex functionality you have automated in your project? Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet. Rate yourself in SQL? Display the employee name who is getting maximum salary? sal ID Salary name 001 100 002 500 003 300 ID 001 002 003 Ename A B C Have you written any test cases while you are in Automation? Manual Testing also will you do or you will work only in automation?

2437


what is the difference between the modular framework and datadriven frame work

2120


How to export quicktest professional results to an .xls file?

798


Explain the concept of how quicktest professional (qtp) identifies object?

765


Could any one tell me "How can i recognize my cursor position using QTP 9.2" Give me a scripts for this

2253


Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

1770


Hi How to retrieve data from web element line by line?

1767


How do client side image and server side image work?

1591