ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Testing  >>  Manual Testing
 
 


 

 
 Automation Testing interview questions  Automation Testing Interview Questions
 Manual Testing interview questions  Manual Testing Interview Questions
 QA Concepts interview questions  QA Concepts Interview Questions
 Mobile Testing interview questions  Mobile Testing Interview Questions
 Test Cases interview questions  Test Cases Interview Questions
 Test Documents Reporting interview questions  Test Documents Reporting Interview Questions
 Testing AllOther interview questions  Testing AllOther Interview Questions
Question
what is the output of this query
selet * from employee where 1=2
 Question Submitted By :: Poonam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the output of this query selet * from employee where 1=2
Answer
# 1
No rows selected.
 
Is This Answer Correct ?    0 Yes 0 No
Codecracker
 
  Re: what is the output of this query selet * from employee where 1=2
Answer
# 2
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.
 
Is This Answer Correct ?    0 Yes 0 No
Rajendra
 
 
 
  Re: what is the output of this query selet * from employee where 1=2
Answer
# 3
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.
 
Is This Answer Correct ?    0 Yes 0 No
Jana
 
  Re: what is the output of this query selet * from employee where 1=2
Answer
# 4
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
 
Is This Answer Correct ?    0 Yes 0 No
Satya
 
  Re: what is the output of this query selet * from employee where 1=2
Answer
# 5
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
 
Is This Answer Correct ?    1 Yes 0 No
Asha
 

 
 
 
Other Manual Testing Interview Questions
 
  Question Asked @ Answers
 
what is the role of testlead in software testing  1
1.While doing regression testing one bug raised due to functionality dependency, what is the bug status that one? IBM11
What is Change and configuration management repositoty Sierra-Atlantica1
For what purpose are virtual users created?  4
Describe the basic elements that you put in defect report?  4
what is traceability matrix?  7
What are teh characters of a good tester Microsoft4
can any body explain about BVA and ECP briefly?  2
What is meant by gui testing?  3
Explain about V-model? AppLabs3
developer says it is not defect.then as a test engineer what u will do? Cognizent7
diff between priorty and severiorty?  5
How to do risk management?  1
what is unit testing? It comes under white box or Black Box testing? Trigent10
diffrence between banking domain and medical domain FlashTECH2
What is meant by Test Script. Example and Explanation on Test Script?Please Answer  2
hi!how to write test cases on SRS?tell me any example which type of certification is usefull for less then 1 yr exp. people in testing? IBM1
Book by Which author is best to use? 1)Erik Van Veenendaal 2)Rex Black 3)Grahum  1
difference between static and dynamic testing( not just definition) as a 4+ experienced guy  3
what is the difference between the focused and enabled?  2
 
For more Manual Testing Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com