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

What do you understand by ‘test effectiveness’ and ‘test efficiency’?

0 Answers  

what is difference b/n client server and web based applications?

1 Answers  

How would you describe the involvement you have had with the bug-fix cycle between Development and QA?

1 Answers  

You are a tester. Now how will you choose which defect to remove in 1000000 defects?

0 Answers  

what are test metrics?

6 Answers   AZTEC,

How to test Volume in Music System?

1 Answers  

What is Crystal Reports ?

2 Answers   Accenture,

Can anybody help me what is the diff between CMM,SEI,PCMM and six sigma?

6 Answers  

What is quality control?

6 Answers   Ordain Solutions,

best trainig institutes and best faculty in chennai for software testing ?

0 Answers  

What are the technical risks involved in Software testing project?

2 Answers   CTS,

What should Development require of QA?

0 Answers  

For more QA Concepts Interview Questions Click Here
Categories