Mention the different types of replication in sql server.

0 Answers  

---

When we can say that is in BCNF?

3 Answers   BitWise,

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Explain database normalization?

0 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

What is difference between inner join and join?

0 Answers  

---

What is the recovery model?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

Which database stores information about replication?

0 Answers  

---

Are resultset updatable?

0 Answers  

---