Answer / asha

I Agree with Satya K
If the Table contanins the columns as
EMPLOYEE table
EmpNo Ename Salary
101 Hello 1000
102 hi 2000
103 dear 3000

When you execute the above query it gives only the
structure of the table...with the blank rows

Ans : EmpNO Ename Salary
is displayed

Answer / codecracker

No rows selected.

Answer / satya

Hi,

For the Query "No Records are displayed." because the
condition is false...The table displays ths structure..with
out the records if the table contains records also..


Regards
Satya.K

Answer / jana

here only the structure of the table is available and what
ever the data is there in the table is not copied into the
other table.

Answer / ajay

Just display only empty table structure

Answer / qaprofessional

This query would copy the structure, when the query is like
select into abc from xyz where 1=2 would result in the
structure of xyz getting copied to abc.

This query would return no values

Answer / rajendra

hai poonam i am rajendra

if you execute query like
selet * from employee where 1=2

here the where condition is meaningless

but you have selected all columns of data from table

it just displays all column names of table without data.

Not only where 1=2 for nay meaningless condition.

if you have still any doubt plz mail me i can send you
answers.

ok byeeeee

Rajendra Prasad Reddy
Mobile:+91-9885162742
Hyderabad.

Give the real-time example for back-to-back testing?

0 Answers  

What is the testing process followed in ur company?

8 Answers   ITC Infotech, Logica CMG,

What is suspension & resumption criteria in Test Plan please explain with example ?

2 Answers   TCS,

Hi, Please answer this qns. "What is the test strategy and list of design characteristics for a login screen?" thank u

1 Answers  

what is the purpose of writing testcases?

3 Answers  

I faced following questions in Polaris Interview. 1. Tell me about u r current organization 2. what is Black box testing? 3. what is white box testing? 4. What is Functional Testing? 5. What is difference between Black box & functional ? 6. what is test plan? 7. what is test strategy? 8. what is difference between Test plan & test strategy? 9. What is smoke testing ? 10 what is sanity testing? 11. who will perform smoke testing? 12. Explain about Agile process? 13. How much you know about QTP? ( I mentioned in my resume as Exposure on QTP) 14. Explain about u r current project? 15. What is the Requirement Traceability Matrix? 16. Can u draw the template for Requirement Traceability Matrix? 17. What is Ad-hoc Testing? 18. What is difference between ReTesting and Regression Testing. 19. Can u explain about Bug life cycle? 20. How can u make sure whether all requirements are covered or not? 21. Can u explain biggest complexity in current project? 22. what is difference between bug severity and priority? 23. Which bug tracking tool is u r using? 24. can u give one example for High severity and low priority bug? 25. can u give one example for High priority and low severity bug? 26. What is security Testing?

5 Answers   Polaris,

wat is the differece between three tier and two tier application

5 Answers   AZTEC,

What is release notes&have u involed in preparing the release notes?

6 Answers  

hi one of the interviewer asked me have you ever created a test plan?

1 Answers  

in manual testing functional testing means to check the behviour of the appln.it is correct or let me know

4 Answers  

what is the function generator?

0 Answers   IBM, MBT,

Gv example of a defect with high priority and low severity? Gv example of a defect with high severity and low priority?

2 Answers   McAfee,