what is the output of the query select * from emp where 1=2

Answer Posted / ganesh

for sure it will display no rows selected
coz for select * from emp give all and because of the where
clause 1=2.......no point in time 1 is eual to 2 or 2 is
equal to 1....so it returns no row.

eg 1=2 ----give no rows
1=1 ---gives all rows
come out of oracle and think as simple logic (is 1=2)....if
yes true else false.....similar of oracle also

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I am DD. I am working as a Tester in e-learning company? IS there scope for content testing? or i have to change to software testing. pls guide me...

1681


What is the difference between Sleep and wait in winrunner what is integration testing and types of testing present what is system testing what is data driven testing what is functionality testing if requirements are given to you then how do you write the test cases for it Account number = Ok cancel For above given form the valid account number starts from 1 to 1000 so is it necessary to input the 1,2,3 ….998,999,1000 test cases to check the conditions of valid account numbers I,e is it compulsory to write 1000 test cases for the above form

2145


What is severity and priority of bug? Give some example.

673


hai friends can u expalin about real time process of testing at the company, like flow diagram

1623


what comments have u given in peer review? tell me at least 3 comments what u have given? july27 brahma412@yahoo.co.in

1517






What is the difference between pilot and beta testing?

712


Write a Test scenario for Outlook Search functionality.

2597


what are the typical problems in web testing?

758


how can u prepare the test plan?

1798


value momentum

1286


How would you test a service oriented architecture (soa) web application?

697


Is an "A fast database retrieval rate" a testable requirement?

1529


How would u test and automate an Antivirus application ?

1537


What is defect validity ratio?

6781


Describe your experiences with code analyzers.

1743