|
SQL Server replication - Interview questions and answer
Test your SQL Server Skills!
|
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
Snapshot Replication
In this kind, snapshot of entire data is copied from publisher to the
subscriber's database on regular interval..................
Read answer
Publisher is the database that transmits its data to another database.
Subscriber is the database that receives data from another
database..............
Read
answer
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
At first data and object is synchronized between publisher and subscribers.
The snapshot is created on the publisher and transmitted to
subscribers..............
Read answer
|
Server clustering on replication involves many manual and tedious
tasks..........
A database is a structured collection of data. Database can be thought as simple
data file......
It is the process of organizing data into related table. To normalize database,
we divide database into tables.....
Distributed Query is a query which can retrieve data from multiple data sources
including distributed data........
Temporary Stored Procedure is stored in TempDB database. It is volatile and is
deleted once connection gets terminated or server is restarted......
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......
A transaction is a set of operations that works as a single
unit. The ransactions can be categorized into explicit, autocommit, and
implicit....
|
