Answer / Jyoti Gautam

Replication in SQL Server is a feature that enables you to distribute and update database data across multiple databases, servers, or sites. It allows for the propagation of changes made to one replica (source) to other replicas (targets), providing real-time or scheduled data synchronization.

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What the different components of Replication and what is their use?

1 Answers  

---

How to apply cascading referential integrity in place of triggers?

1 Answers  

---

How to delete database objects with "drop" statements in ms sql server?

1 Answers  

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

What are subqueries in sql server? Explain its properties.

1 Answers  

---

What is factless fact table? : sql server analysis services, ssas

1 Answers  

---

How do clustered indexes store data?

1 Answers  

---

What is the synonym of join?

1 Answers  

---

write coding for importing sql data into a word excel...

1 Answers   Oracle,

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---