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
- 0 Answers
- 1995 Views
- Covansys, I also Faced
- E-Mail Answers
how can i wrtie testcases for huge data
How do you start your QA if there are no system requirements?
Some questions generally asked but i haven't correct answer. Becuase interviewer asking with example. Like : need to verify the google with 4 functionalty. 1. How does we estimate the Test case. 2. How does we estimate the automation testing process.
What are the responsibilities of a qa analyst?
What are the benefits of destructive testing?
What are your salary expectations?
Tell me some of the test cases for Notepad Application?
What is Pesticide Defect?
How do you know that your test cases will meet the requirement that the client required for the application.
What is the quality audit?
What is the role of QA in a development project?
What is the difference between web, window, desktop and client server application testing?
Automation Testing 
