Answer / aruna gopalakrishnan

Peer-to-peer replication (also known as multimaster
replication) is a configuration that has the following
characteristics:

Replication occurs between tables on two or more servers.
Updates on any one server are replicated to all other
associated servers.
Applications on any of the servers can update the same rows
and columns in those tables at the same time.
All servers are equal peers with equal ownership of the
data; no server is the "master" or source owner of the
data.

List some advantages and disadvantages of stored procedure?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---

What are the properties of the transactions?

0 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

---

How to set database to be read_only in ms sql server?

0 Answers  

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

How many joins in sql server?

0 Answers  

---

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---