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 >> QA Concepts
  2. Suggest New Category

hi,
they have given 2 tables to write quries in SQL SERVER 2000
based on table as follows .
1st table :author:
COLUMNS AS FOLLOWS
pk. AUTHOR
F_NAME
DOB
NATIONALITY

2ND TABLE BOOKS:
COLUMNS AS FOLLOWS;
PK ISDN
F.K AUTHOR
LANGUAGE
PUBLISH_DATE;

1) RETRIVE author who is indian and hindi
write in a) as joins b) sub quries
2)retrive who is younger author ;
3)retrive author who wrote more than one book in different
language.
4)retrive author who has wrote in different language in
each year
write all queries in sql for sql server



Question Posted / ravi148

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More QA Concepts Interview Questions

can u explain what is concurrancy in testing

3 Answers   Sapient,

What is 'Context Driven Testing' in Agile Method?

3 Answers   L&T,

What do you like least about Quality Assurance/Testing?

4 Answers  

Explain what is mr and what information does mr consists of?

0 Answers  

anyone can explain about SixSigma process.

1 Answers  

How do you train another QA engineer?

0 Answers   Lucent,

What is Comparision Testing?

2 Answers  

hey, i recently attended 2 interviews and they asked whether I used qamonitor of softsmith. any help on what it does?

2 Answers  

What is role and responsibility of a senior software testing engineer in the company?( Day to day activities)

1 Answers   Infogain,

In an interview,the Interviewer asked me what are the reasons For the software has bugs? could u pls. explain the General reasons ..

5 Answers   Infeneon Technologies,

What actually a SQA Tester do in His/ Her first (entry level) Job?

0 Answers  

What is the rule of a "test driven development"?

0 Answers  

For more QA Concepts Interview Questions Click Here
Categories