vkm


{ City } hyderabad
< Country > india
* Profession * srtest engineer
User No # 30392
Total Questions Posted # 5
Total Answers Posted # 2

Total Answers Posted for My Questions # 15
Total Views for My Questions # 28052

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 1
Questions / { vkm }
Questions Answers Category Views Company eMail

I have to automate webpage. If I click one hyperlink2 it will take 2 hrs to open. How to automate hyperlink2?

Cap Gemini, Polaris,

4 QTP 6482

. My application is updating the user information in the application. Every time it is Adding on record in my application and Validating the information like “Record has added successfully”. Which Check point I have to put in this situation? Why?

Polaris,

5 QTP 6544

How many function you use in your application?

Polaris,

2 QTP 4712

What is deference between normal QTP testing and descriptive programming?

Polaris,

4 QTP 8662

I have attended Anovatek Software QTP interview. They will give us computer and one web based application with QTP. We have to automate some records (already updated records or new records) using QTP Data driven testing. But we should use for loop? Can any one know how to do data driven testing using For loop?

VB Script 1652



Answers / { vkm }

Question { DELL, 16531 }

I have a table EMP in which the values will be like this

EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30

I want to delete only duplicate Rows. After Delete I want
the output like this

EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30




Answer

I have tried this query in my PC.Very simply I was able to
remove all duplicate rows.
Please try below query it will work out.

SELECT DISTINCT*FROM EMP(TableName);

You will get below table
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30


Suppose if you have different ENAME but you want only
selected ENAME without duplicate records.
Where We can use below query.

SELECT DISTINCT*FROM EMP WHERE ENAME IN('RAM','RAJ','ANIL');

Please correct me if I am wrong.

Is This Answer Correct ?    1 Yes 1 No

Question { Polaris, 6544 }

. My application is updating the user information in the
application. Every time it is Adding on record in my
application and Validating the information like “Record has
added successfully”. Which Check point I have to put in
this situation? Why?


Answer

But the value is dynamically changing. If we put check point
test will fail. Please correct me if i am wrong.

Is This Answer Correct ?    0 Yes 0 No