SQL Server Replication interview questions

          
Download HR interview
Download CV samples
Download IT interview
Interview questions

SQL Server replication interview questions

SQL Server replication - Interview questions and answer

<<Previous  Next>>

Test your SQL Server Skills!

Sql server part 1 (40 questions)  
Sql server part 2 (28 questions)
ASP.NET (41 questions)
Database concepts (20 questions) 

What is Replication?

Replication is the process of distributing data from one database to another on the same server or servers connected through LAN or the internet................
Read answer

What are the types of Replication?

Snapshot Replication
In this kind, snapshot of entire data is copied from publisher to the subscriber's database on regular interval..................
Read answer

Define the terms used in Replication.

Publisher is the database that transmits its data to another database.
Subscriber is the database that receives data from another database..............
Read answer

Describe the replication agents that SQL Server supports.

The Snapshot Agent creates snapshot files and stores on the distribution database. It also keeps track of synchronization status in the distribution database. This is used in all kinds of replication..............
Read answer

Describe in brief working of Replication.

At first data and object is synchronized between publisher and subscribers.
The snapshot is created on the publisher and transmitted to subscribers..............
Read answer

<<Previous  Next>>
Explain the implications of server clustering on replication.

Server clustering on replication involves many manual and tedious tasks..........

Describe in brief Databases and SQL Server Databases Architecture.

A database is a structured collection of data. Database can be thought as simple data file......

Define Normalization and De- Normalization.

It is the process of organizing data into related table. To normalize database, we divide database into tables.....

Define Distributed Query and Linked Server?

Distributed Query is a query which can retrieve data from multiple data sources including distributed data........

Define temporary and extended stored procedure.

Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted......

What are the lock types?

Shared Lock allows simultaneous access of record by multiple Select statements. Shared Lock blocks record from updating and will remain in queue waiting while record is accessed for reading......

Define transaction and transaction isolation levels.

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

Write your comment - Share Knowledge and Experience

 

Latest placement tests
Latest links
 
Home | Write for us and earn | My key skills | About us | Sitemap | Contact us