SQL server replication interview questions and answers

SQL server replication interview questions and answers for freshers and experienced candidates. These interview questions and answers on SQL server replication will help you strengthen your technical skills, prepare for the interviews and quickly revise the concepts. Many candidates appear for the interview for one role - many of the them give the right answers to the questions asked. The one who provides the best answer with a perfect presentation is the one who wins the interview race. The set of SQL server replication interview questions here ensures that you offer a perfect answer to the interview questions posed to you.

Interview questions

SQL Server replication interview questions


<<Previous  Next>>

What are the advantages and disadvantages of merge replication?

SQL Server replication - August 29, 2008 at 18:00 PM by Amit Satpute

What are the advantages and disadvantages of merge replication?


  • It provides built-in and custom conflict resolution capabilities.
  • It allows for the synchronization of data from multiple tables at one time.
  • It provides rich data replication options like selection of article types and filtering and identity range management.


  • Merge replication requires more configuration and maintenance at the server
SQL Server replication - May 19, 2009 at 18:00 AM by Rajmeet Ghai

What is Replication and Database Mirroring?

Database Mirroring allows two copies of a database on different computers. Clients can get access to only one database called as”principal” database. Any changes applied to principal database, are applied on the copy also called as the mirror. This is achieved by applying the transaction log for every insert, update, or deletion made on the primary database. This increases the availability of a database incase of a failure.

<<Previous  Next>>

Also read

Describe in brief system database.

Answer - Master database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master.....

Define Stuff Function and Replace Function.
Describe in brief SQL Server monitoring ways.

Answer - SQL Profiler is a tool that stores events from the server. SQL Profiler saves the events in the trace file......

Define transaction and transaction isolation levels.

Answer - A transaction is a set of operations that works as a single unit. The ransactions can be categorized into explicit, autocommit, and implicit....

SQL Server Optimization Tips

Answer - Restricting query result means return of required rows instead of all rows of the table. This helps in reducing network traffic......

Having clause and Where clause

Answer - Both are used for filtering of records based on filtered criteria.....

Describe in brief authentication modes in SQL server.

Answer - This is the default and recommended security mode. In this mode, access to SQL server is controlled by Windows NT.....

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring