Friday, August 29, 2008

FAQ - QTP

1) What is the automation?
2) What is QTP? (which type of tool, using script)
3) Explain about Test Pane?
4) How many panes are there in QTP 9.2?
5) What are the differences between Expert view and Keyword view?
6) What is the use of Information pane?
7) What is the use of Debug viewer ?
8) What is the use of missing resource?
9) What is the Active screen?
10) At Run time how does QTP identify the object in the application?
11) How to add properties to the mandatory properties?
12) What are the differences between Location and Index?
13) Enable smart identification is applicable for windows objects / application?
14) When Enable smart identification invoke?
15) How many filters are there in Enable smart identification?
16) How “Enable smart identification” identifying objects?
17) What is the abs – x & abs – y and x & Y in properties?
18) What is the Virtual Object?
19) How to map virtual object to standard object?
20) What is the custom object?
21) How to add a custom method to a particular object?
22) How many types of the Object Repositories in QTP?
23) What the differences are between Local and Shared object repositories?
24) Can we merge two .tsr files?
25) Where we can merge two shared object repository files?
26) which mode .tsr file will open in object repository manager?
27) How can we associate shared object repository file to a particular action?
28) Can we develop scripts with out Object repository?
29) What are the built in Add-in’s in QTP?
30) What is the use of Add-Ins?
31) What is the default object type in QTP?
32) What is the synchronization?
33) How many types of synchronization points are there in QTP?
34) Without Wait property can we handle sync?
35) What is the default synchronization time in QTP?
36) Can we change default synchronization time?
37) What are the differences between Action & function?
38) What is the difference between Call to copy of Action and Call to
Existing Action?
39) How many actions can we add/Insert in a particular test?
40) How many sheets can we add to a particular test?
41) What are the differences between Global sheet and Local sheet?
42) Can we see more than one action at a time in export view?
43) How many types of actions are there in QTP?
44) What is the limitation of the QTP?
45) How many types of extensions we have for the resource files (Library functions)?
46) What is the difference between .VBS and .QFL files?
47) How can associate a .VBS / .QFL file with a particular test?
48) How many types of Environment variables we have in QTP? (
49) How many types of the Event Status (Event Report) are there?
50) Casting functions (CInt, Cstr….), String functions (Instr, Mid, split, ….)
51) What are the differences between Get Ro Property and out put value?
52) What the differences are between function and sub producer?
53) In Browser object what is the creation time property?
54) How to delete cookies in a browser?
55) How can we take screen shot at run time?
56) How can we create a folder at run time?
57) When script execution started I want to close all open browsers with QTP code, is it possible, if yes, what is the code?
58) What is Action parameter and test parameter?
59) Can we execute our script in IE 7 browser?
60) Can we execute our script in firefox( Mozilla) and Netscape Browsers?
61) Can we open our script at outside QTP tool location?
62) What is the Data Driven test?
63) Write the code for Data driven?
64) How can we get the row count of local sheet?
65) How can we pass data from local sheet as input to application?
66) Where can we see Output parameter values?
67) How can add sheet to data table at runtime?
68) Is it possible, can we add column to a particular sheet at runtime?
69) What is the Option explicit?
70) How do you filter warnings in reports at runtime?
71) How to handle Run-time errors?
72) When we are getting Overflow error?
73) How to connect Data base?
74) What is difference between User Specific and System specific DSN?
75) How can we get records count in displayed query data?
76) When we are using Regular expression?
77) What is the use of Recovery Scenarios?
78) What are the steps in Recovery scenario creation?
79) What are the Trigger Event types in the recovery scenario?
80) How many post-Recovery test run options are there?
81) What is the Check Point?
82) What is the Output value?
83) How you can capture Runtime Object Properties Value?
84) How to connect Quality center with QTP?
85) How to get Current action name?
86) How to get count of actions in a particular test?
87) What is the difference between screen shot and Active screen?
88) How to import excel sheet to a particular test?
89) How to export data table in to local machine?
90) Can we send Email through QTP?
91) Can we schedule our script execution?
92) What is the Get To Property?
93) How many record methods are there?
94) What is the use of screen record? What is the extension of the movie record file?
95) How many run modes are there?
96) How many update run modes are there?
97) How QTP identifying the objects?
98) What is the local object repository file maximum memory size?
99) Does Shared object repository file have memory size limitation?
100) What is the DOM (document Object Model)?
101) How location value is assigning to the object?
102) How Index value is assigning to the object?
103) How many types of ordinal identifiers are there?
104) If logical name changed in local Object repository, it will update in script?
105) If logical name changed in Share Object repository, it will update in script?
106) If any object deleted in object repository, how it will effect to the script?
107) What is the test object and runtime objects?
108) How do you handle data table and active screen visibility?
109) What is the default status of the smart identification for web objects?
110) Is smart identification default turn on to all web objects?

Thursday, August 28, 2008

How to connect Database?

I) DB - connectivity (Oracle): -
Set Con=Createobject("ADODB.connection")
Set strRecordSet=Createobject("ADODB.recordset")
connStr = "Driver={Microsoft ODBC for Oracle};Server=XXXX;Uid=XXXX;Pwd=XXXX;"
OR
'connStr = "Provider=OraOLEDB.Oracle;Server=XXX;Uid=XXX;Pwd=XXX;"
Con.open connStr
strRecordSet.Open Query,Con, 3,4,1

How to do tns entry:-

C:\oracle\product\XX.XX.\client\NETWORK\ADMIN

II) DB - connectivity (SQL): -

Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
connstr = "Driver={SQL Server};Server=XXX;Database=XXX;Uid=XXX;Pwd=XXX;"
SQL_Statement = XXXXXXX
conn.Open connstr
rs.Open SQL_Statement, conn, 3, 2, 1

Thanks
Surya P Reddy