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...


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.

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

Please can any one tell me 1).Types of reports 2).Types of Meetings.

0 Answers  


Where do you get your expected results?

7 Answers  


write test cases on wall

0 Answers  


you will be given a program and asked to write the Test Data and expected output for the same. for eg: there is a program which returns the sum of largest two numbers in an integer array.

1 Answers   Amazon,


In any application there are so many fields. So tester have to test each field with Special chars., Alphabetic value, Alphanumeric value, Blank Space. etc. I am testing with all these inputs but should I have to consider these into test cases. Because rather than these there many functionalities to check.Please Guide me properly

2 Answers  


can any body tell me vat is the status of the bug when it is going for retesting and where we write the bugs in case of retesting

2 Answers  


What are the reasons why parameterization is necessary when load testing the Web server and the database server?

1 Answers  


Test case on Air conditionar

1 Answers  


What is the priority in fixing the bugs? Explain the severity u rate for the bugs found?

2 Answers  


How is your project connected to the Database...tell the procedure??

2 Answers   SuperValu,


Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position

0 Answers  


What makes a good QA or Test Manager?

1 Answers   Crea,


Categories