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

What is a test environment?

2 Answers  

what is vss

2 Answers  

how we write test cases to brs,srs,hlds,llds

0 Answers  

what is the difference between bug and defect? what is the definition of bug? what is the definition of defect?

3 Answers   Core Solutions,

What is the input for System testing?

6 Answers  

How will you give estimation when preparing Test Plan

1 Answers   Virtusa,

How to create a load manualy in web based testing

1 Answers   NetSity,

Test cases for IE 6.0

1 Answers   Wipro,

What types of code coverage do you know?

1 Answers   3i Infotech,

Five positive and 5 negative test cases for Coffee vending machine

1 Answers   PWC,

How many tabs are in QC?Name some tab

3 Answers   Amdocs,

Can you explain capability levels in continuous representation?

0 Answers  

For more Manual Testing Interview Questions Click Here
Categories