Answer / Himanshu Raj Panchhi

Replication in SQL Server is required to distribute copies of database objects and data to multiple sites for load balancing, data redundancy, or to provide access to remote users. It allows a centralized database to be duplicated at one or more remote locations, ensuring high availability and scalability.

Explain different types of self contained sub query?

1 Answers  

---

what's the information that can be stored inside a bit column? : Sql server database administration

1 Answers  

---

What is equi join with example?

1 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

explain different types of joins? : Sql server database administration

1 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

How can you tell if a database object is invalid?

1 Answers   MCN Solutions,

---

What is onf in normalization form?

1 Answers  

---

What do you understand by replication in sql server?

1 Answers  

---

What are the properties of primary key?

1 Answers  

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---