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 the purpose of testing?

0 Answers  

Anything you know about host file

1 Answers   SunGard,

What are your salary expectations?

7 Answers   IBM,

What is the difference between system integration testing and end-to-end testing? With examples pls

1 Answers  

Tell me in which of the software testing phase is qa involved & qc not involved?

0 Answers  

What is the involvement of tester in SDLC?Explain.

3 Answers   AZTEC, TCS,

WHAT IS ENTRY CRITERIA AND EXIT CRITERIA

6 Answers   HCL,

what is web testing and what should you test in web testing?

2 Answers  

A cube of side 4cm is painted with 3 colors red, blue and green in such a way that opposite sides are painted in the same color. This cube is now cut into 64 cubes of equal size. 1. How many have at least two sides painted in different colors. 2. How many cubes have only one side painted. 3. How many cubes have no side painted. 4. How many have exactly one side not painted.

2 Answers   PSA,

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

0 Answers  

Can anyone listout major scenarios for a payment submission web page???

1 Answers   Xansa,

Who in the company is responsible for Quality?

3 Answers  

For more QA Concepts Interview Questions Click Here
Categories