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 replication?
where do u use Go Keyword?
 Question Submitted By :: Sam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is replication? where do u use Go Keyword?
Answer
# 1		 
Synchronizing data and object between systems .

For example i have 50gb data in Delhi server(Publisher or
source ) i need to replicate into tow locations one into
mumbai server 10gb data  (subscriber ) and another one into
kerala server 20gb data.

Publisher  ---Source
Subscriber ---destination
Distributor--- Receive from publisher and forward to sub     

Type of replications

1)Snapshot (one way)
Data refresh of the subscriber every time you synchronize.

2)Merge Replication (Two way)
Both publisher and subscriber can make change to the data.
Conflict :- When two participant chenge the same row at same
time

3)Transactional replication
As change made at the publisher its send to the distributor
and distributor into subscriber
 
Is This Answer Correct ?    4 Yes 0 No
Jijo
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Difference between Triggers and Stored Procedure Protech9
Which system tables contain information on privileges granted and privileges obtained  1
What are sub-queries? Give example? In which case sub-queries are not feasible? Infosys3
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"  6
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
Which system table contains information on constraints on all the tables created?  2
How to tune a stored procedure?  5
how to select 5 to 7 rows from a table, which contains 10 rows? IBM14
What is Trigger? Misys2
What is the difference between windows authentication and sql server authentication HCL4
How m-m relationships are implemented?  1
how do u do Performance tunning ? Satyam1
In which year relase the 7.0& 2000 & 2005?  1
What is the diff between Dynamic queries and static queries ICS-Integrated-Computer-Solutions1
How do you check the performance of a query and how do you optimize it?  1
logshipping is Any difference 2000 and 2005?  1
How to get the count of distinct records. Please give me the query? Value-Labs5
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required  2
What is INTVAL( )and where we use Plz any body help me  1
How to find the date and time of last updated table? Teledata4
 
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