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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 database replicaion? What are the different types 
of replication you can set up in SQL Server?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is database replicaion? What are the different types of replication you can set up in SQL Server?
Answer
# 1
Replication is the process of copying/moving data between 
databases on the same or different servers. SQL Server 
supports the following types of replication scenarios: 

Snapshot replication 
Transactional replication (with immediate updating 
subscribers, with queued updating subscribers) 
Merge replication 
 
Is This Answer Correct ?    3 Yes 0 No
Swapna
 
  Re: What is database replicaion? What are the different types of replication you can set up in SQL Server?
Answer
# 2
Database replication is the creation and maintenance of 
multiple copies of the same database.

In most implementations of database replication, one 
database server maintains the master copy of the database 
and additional database servers maintain slave copies of 
the database.

Database writes are sent to the master database server and 
are then replicated by the slave database servers.

Database reads are divided among all of the database 
servers, which results in a large performance advantage due 
to load sharing. 

In addition, database replication can also improve 
availability because the slave database servers can be 
configured to take over the master role if the master 
database server becomes unavailable.
 
Is This Answer Correct ?    1 Yes 0 No
Sachin Rathi
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
when inserting to a table how many rows will be effected using triggers  1
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000? Infosys1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?  1
Explain the architecture of SQL Server?  2
how to rename the table  3
What are the types of backup and tell me the difference between full and differential backup? TCS3
About types of indexes in SQL server ? Cognizent1
What is normalization in Database ?  4
HOW TO RENAME A COLUMN NAME  2
Whether the updations made to the views reflect the original records in the table NIIT5
Which system table contains information on constraints on all the tables created?  2
what is the cursor life span? Evalueserve5
What are the magic tables in SQL Server 2000? Infogain5
what is the importence of the trigger in sqlserver2000? ATI1
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..  2
What is an Index? Yardi-Software3
What is a NOLOCK?  3
How are SQL Server databases physically stored under Windows 2000?  1
How To delete duplicate record from a particular table? eXensys10
what is the purpose of creating view is sql server 2000 Wipro9
 
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