1. Categories >> Software >> Testing >> Manual Testing
  2. Suggest New Category

Can any one give answer for this question. Suppose im having
employee table with fields, eno, ename, dept, address1,
address2, address3. In address field employee can fill only
address1 or address2 or address3... at a time he can fill
three address fields. now i want all employee names who
filled only one address field.. Plz its urjent can any one
give querry.. Thanks in advance.

Question Posted / shashipalreddy

Answers were Sorted based on User's Feedback



Can any one give answer for this question. Suppose im having employee table with fields, eno, ename..

Answer / raj

Select ename from employee
where (adress 1 is not NULL and (adress 2 and address
ISNULL)) OR (adress 2 is not NULL and (adress 1 and address
3 ISNULL)) OR (adress 3 is not NULL and (address 2 and
address 1 ISNULL))

Is This Answer Correct ?    29 Yes 0 No

Can any one give answer for this question. Suppose im having employee table with fields, eno, ename..

Answer / nitin sharma

select ename from employee where adress2 and adress3 is NULL;

Is This Answer Correct ?    5 Yes 13 No

Post New Answer

More Manual Testing Interview Questions

1.What is end-to-end Testing 2.What ist the difference between WebBased Testing and Application Testing

5 Answers   College School Exams Tests, Mphasis, Tech Mahindra,

In whic page of QC , we run our Test case, or from where we run our Test cases from QC?

2 Answers   Amdocs,

How to test an application if it was already developed and it is in the state of changing the functionality according to the customer requirement How to start testing in this situation. I got an application to test.It is a desktop application.It is still developing and started 8 months back.how can i start to test this application? Is it the right way to test it in "Random testing"? or writing the testcases from page one and executing them.i have an another responsibility that is I have to automate that application. can anyone tell me what is the process to test this application.

0 Answers  

If client give you a project then which testing you will perform first

0 Answers  

I am sujili(frm chennai) new commer for this site? I have some doubt's pls clarify it..... I finished my B.Tech 2004 pased out(CSE),(sujli2000@yahoo.com) and S/w Testing Course(2007) Now iam serarching a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,for Banking,ERP Projects etc.

3 Answers  




1...HOW TO RETRIEVE NUMBER FROM ALPHA NUMERIC VALUE? 2.. HOW TO CAPTURE A DYNAMIC VALUE IN WEB APPLICATION? 3.. HOW TO GET THE OUTPUT VALUE FROM ONE TRACTION AND USE THIS OUTPUT VALUE AS INPUT OF ANOTHER TRANSACTIONS? 4... HOW TO COUNT A WEB TABLE ROW? ... WHAT IS QC LIFE CYCLE? 6...WHAT IS IMPACT ANALYSIS? HOW TO DO IMPACT ANALYSIS IN PROJECT?

2 Answers   Wipro,

what is sanity testing and smoke testing?

3 Answers   Crea,

wat kinds of documents requied during regression testion ? at time regression testing is done? can we do it repeatdly

2 Answers  

what are general aspects of security testing?

3 Answers   Infosys,

iam new testing, i want improve writing test cases and bug defect etc? any on give suggestion pls?

0 Answers   Satyam,

Write UI Test case, Integration Test case, Functional Test case & Performance Test case for the File Menu for MS-Word?

0 Answers   eMids,

i have doubt suppose iam purly working in manual, when i will work on sql and performence testing? pls any one clarify doubt?

3 Answers  

For more Manual Testing Interview Questions Click Here
Categories