1.

What Type Of Locking Occurs During The Snapshot Generation?

Answer»

Locking depends on the TYPE of replication used:

  • In snapshot replication, the snapshot agent locks the object during the entire snapshot generation process.
  • In transactional replication, locks are acquired initially for a very brief TIME and then released. NORMAL operations on a database can continue after that.
  • In MERGE replication, no locks are acquired during the snapshot generation process.

Locking depends on the type of replication used:


Discussion

No Comment Found

Related InterviewSolutions