Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How will you determine when to stop testing?

0 Answers  

what is the outcome of testing?

6 Answers  

What are the modules of quality center?

0 Answers  

What is the difference between Usability testing and Exploratory Testing?

7 Answers   Religare,

what is mean by funtionality testing and performance testing,and what is the difference?

6 Answers  

How to do the performance testing Manualy? Do u have a test case for that?

1 Answers  

I have 2+ experience in manual testing but I can not use any bug tracking tool. I use excel sheet & mail that sheet to developer now I wan to change company is there any effect.

4 Answers   Cap Gemini,

what is Middleware? can anybody explain me?

2 Answers   AZTEC,

What is the first query u encounter to test a database..?

2 Answers   IBM,

Dear friends, I am Ravi, was working as a Test Manager and quit the job due to some personal reasons. I need to get into job at any cost, as it is very critical situation for me. Now I am preparing for interviews, and I seed your help. Please mail me at globalpease2008@gmail.com I'll definitely share all those topics in this form too.... Expect your help and thanks in advance. Regards, Ravi

3 Answers  

how do i know that i have to do white\Black box testing

4 Answers   CTS, Wipro,

what documents are used to write testcase for integration testing and system testing?

3 Answers  

For more Manual Testing Interview Questions Click Here
Categories