What is Peer to peer Replication?
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.
| Is This Answer Correct ? | 7 Yes | 0 No |
What are the advantages of using third-party tools?
How global temporary tables are represented and its scope?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Explain cross join or cartesian product in sql?
What is NOT NULL Constraint in sql server 2012?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is an index in sql?
What is sql injection? How to protect against sql injection attack?
How to create an index on an existing table in ms sql server?
Explain DBCC?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)