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

2262

---

What is your biggest failure in life? How did you overcome it?

1301

---

What is framelayout ?

1013

---

Does caching have a negative effect on your load testing results?

1203

---

Performance of our work in the pega is measured using?

544

---

Why entry interface is used in map?

985

---

How we can find out face expression ,what approach should be followed (like skin detection) ?

1923

---

How to find ECC system, GRC system and BI system ?

1276

---

bus bar design conditions and sizing pls tell me quickly

1948

---

Define a full binary tree ?

1086

---

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

834

---

Can you brief the hurdles you faced during Automation testing?

1111

---

What is equivalent conductivity?

1285

---

Explain the concept of ssi ?

1114

---

Name the component u would expect to find in a switchgear assembly?

2084

---