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 to test login page or web login page? are they difference?

1 Answers  

Suppose that your're running tests on the windows calculator and find that 1+1=2,2+2=5,3+3=6,4+4=9,5+5=10 and 6+6=13. Write a bug title and Bug Description that effectively describes this problem?

9 Answers   FCG,

you filed a bug that has high severity & high priority what happens till it gets fixed(that means what u do till it gets fixed)? Urgent

3 Answers   3i Infotech,

Guys, can any one of u give the realtime example for Black Box Testing

1 Answers  

What kind of input do we need from the end user to begin proper testing?

0 Answers  

In usability testing we check spelling, content, look and feel, color combination, link or menu navigation? please let me know more about usability testing.

0 Answers  

Write four good test cases on refill ball pen?

10 Answers   iFlex,

what is the test case for bank check leaf??

5 Answers   IBM,

When we use Boundary Value Analysis and Equivalence Partion? Which one is best?I heard that ANy one of this technique useing by a comany...is it right?

3 Answers  

Mainly how many types of reviews are present?and what is the importence of reviews?

4 Answers   Crea,

What is Concurrency Testing?

1 Answers   PanTerra,

have you ever performed Back End Testing,HOW?

3 Answers  

For more Manual Testing Interview Questions Click Here
Categories