ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What is Peer to peer Replication?
 Question Submitted By :: Sridhar Sahoo
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is Peer to peer Replication?
Answer
# 1
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 ?    0 Yes 0 No
Aruna Gopalakrishnan
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records. 247Customer3
Which virtual table does a trigger use? TCS6
What is a Lock and let me know Different types of locks?  1
From where can you change the default port?  3
What are defaults? Is there a column to which a default can't be bound?  2
What are Magic Table? Evalueserve15
What is Transaction?  2
What is SQL server agent? SAP-Labs2
The Difference between 'Count' and 'Count(*)'  12
write the query for find the top 2 highest salary in sql server TCS23
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.  2
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2 HCL2
What is difference between Triggers and store procedure?  2
What is a function? Give some example?  2
Which institute is best for SQL Server 2005 Training?  5
How m-m relationships are implemented?  1
What is an index? Yardi-Software7
wat is the main diff between sql server 2000and sql server 2005 Jade-Software6
What are the types of backup and tell me the difference between full and differential backup? TCS3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com