Grab Deal : Flat 30% off on live classes + 2 free self-paced courses! - SCHEDULE CALL

Demystifying Distributed Transactions: Question And Answer

Q.1. Can Begin Transaction be Used to Bind Other Similar Operations Within a Single Transaction?

Ans:- Unfortunately, BEGIN TRANSACTION is only applicable to local transactions involving data in a table. These transactions do not apply to an in-memory cache because there is no transaction logging mechanism. For those interested in learning more about distributed transactions, there are various Online SQL certifications available to explore.

Q.2. What does The Term Resource Manager Mean in a Transaction?

Ans: Transactions, whether database-related or not, manage resources. A resource manager is a logical entity responsible for handling resources in a transactional manner (RM). It can be a subroutine, a function, a DLL, an executable, a machine, or anything that supports transactions. An RM has the ability to enlist itself in an ongoing transaction, thereby supporting transactional capabilities.

Q.3. What does The Term Transaction Manager or Transaction Coordinator Mean?

Ans: Suppose an RM manages its resources transactionally by enlisting in a currently running transaction. In that case, an external entity must manage the transaction. This entity coordinates multiple RMs enrolled in the same transaction, acknowledging new transaction requests, and sending success and failure notifications. This entity is called a transaction manager (TM), transaction coordinator (TC), or distributed transaction coordinator (DTC). Microsoft Windows offers two familiar transaction coordinators: the Lightweight Transaction Manager (LTM) and the Microsoft Distributed Transaction Coordinator (MS DTC). Online SQL certifications training courses are available to learn more about this topic.

Q.4. Are TC and DTC the Same?

Ans: It should be noted that a TC is not always a DTC. Some RMs with transactional capabilities may not require a TC. For instance, SQL Server can manage a transaction independently if it is restricted to a single database. In such cases, SQL Server does not consult the MS DTC for local transactions. To understand this better, it's essential to read about the typical implementation of a distributed transaction, such as the two-phase commit process.

Q.5. What does The Term Two-phase Commit Mean?

Ans: A two-phase commit process is a common method of performing a distributed transaction. In this process, a transaction involves two RMs and a DTC:

  • The transaction initiator asks the DTC for a transaction.
  • The transaction initiator asks the RMs to complete their tasks as part of the same transaction, enlisting them within the transaction.
  • The RMs proceed with their work and notify the DTC of a successful outcome while maintaining a rollback mechanism. This is the preparation phase.
  • Once the DTC receives success notifications from all enlisted RMs, it issues a notification to make the changes permanent. This is the commit phase, and the distributed transaction is completed.

Q.6. Does Distributed Transaction Coordinator Engage With The Resource Manager?

Ans: The DTC on a Windows machine, MS DTC, frequently communicates with the various RMs involved in a transaction. However, this communication may impact the application's performance due to network roundtrips and might be blocked by a firewall. To learn more about Resource Managers, consider taking some SQL training courses.

Q.7. Why does The Resource Manager Use The Serializable Isolation Level?

Ans: RMs that join a distributed transaction often use the serializable isolation level. This level provides a perfect transaction with no dirty reads, phantom reads, or non-repeatable reads, making it the simplest architecture to implement for data consistency. However, this advantage comes at the cost of a significant drop in performance.

Q.8. How can a Resource Manager Enlist Within a Transaction?

Ans:- An RM can enlist in a transaction in various ways, depending on the scenario. Some enlistment methods include:

  • Volatile Enlistment
  • Durable Enlistment
  • Promotable Single-Phase Enlistment

Q.9. What is Volatile Enlistment?

Ans: Volatile enlistment is suitable for RMs that work with volatile (non-permanent) resources. In this scenario, if the RM cannot perform the commit phase of a distributed transaction, it is not required to recover the prepare phase explicitly. The Lightweight Transaction Manager (LTM), a lightweight TC, typically manages volatile enlistment scenarios, such as managing an in-memory cache where data is temporary. To learn more about this, an Online SQL certification can be beneficial.

Q.10. Explain Briefly About Durable Enlistment.

Ans: Durable enlistment is necessary for RMs with permanent (durable) data dependent on the transaction for consistency. For example, when writing to a disk file, the RM must prepare a transaction log to handle graceful rollback if a recovery is requested. To understand this further, consider exploring Online SQL server training.

Q.11. What is The Promotable Single-Phase Enlistment?

Ans: A transaction's nature can change when new RMs enlist, and this may lead to promotion to MS DTC. For example, a SQL Server database can manage a transaction on its own if limited to a single database. However, if a second SQL Server connection enlists itself in the same transaction, it will be promoted to MS DTC. This typically happens when RMs are no longer capable of managing the transaction independently. Online SQL server training can provide more insights into this topic.

Q.12. Explain The Disadvantages of MS DTC?

Ans: The promotion to MS DTC comes with certain disadvantages, such as a higher isolation level and increased transaction cost. However, it is crucial to use MS DTC when needed, as it proves to be a lifesaver in certain scenarios.

Q.13. State The Rules for The Promotion of a Transaction From LTM to MS DTC.

Ans: Transactions are promoted from LTM to MS DTC based on specific events, including the involvement of durable resources that do not support single-phase notifications, enlistment of two durable resources supporting single-phase notification in the same transaction, and notification to marshal a transaction to another.NET AppDomain or Windows process. For a deeper understanding of these rules, consider Microsoft SQL certification training.


Transactions play a critical role in maintaining data integrity and consistency within database management systems. Understanding terms like Resource Manager, Transaction Manager, and Two-phase Commit is vital in comprehending distributed transactions and their management. The use of MS DTC and various enlistment methods can significantly impact a transaction's performance and behavior. By grasping these concepts, database professionals can optimize their applications and ensure efficient transaction management.

Trending Courses

Cyber Security

  • Introduction to cybersecurity
  • Cryptography and Secure Communication 
  • Cloud Computing Architectural Framework
  • Security Architectures and Models

Upcoming Class

-0 day 14 Jun 2024


  • Introduction and Software Testing
  • Software Test Life Cycle
  • Automation Testing and API Testing
  • Selenium framework development using Testing

Upcoming Class

-0 day 14 Jun 2024


  • Salesforce Configuration Introduction
  • Security & Automation Process
  • Sales & Service Cloud
  • Apex Programming, SOQL & SOSL

Upcoming Class

-0 day 14 Jun 2024

Business Analyst

  • BA & Stakeholders Overview
  • BPMN, Requirement Elicitation
  • BA Tools & Design Documents
  • Enterprise Analysis, Agile & Scrum

Upcoming Class

-0 day 14 Jun 2024

MS SQL Server

  • Introduction & Database Query
  • Programming, Indexes & System Functions
  • SSIS Package Development Procedures
  • SSRS Report Design

Upcoming Class

-0 day 14 Jun 2024

Data Science

  • Data Science Introduction
  • Hadoop and Spark Overview
  • Python & Intro to R Programming
  • Machine Learning

Upcoming Class

7 days 21 Jun 2024


  • Intro to DevOps
  • GIT and Maven
  • Jenkins & Ansible
  • Docker and Cloud Computing

Upcoming Class

1 day 15 Jun 2024


  • Architecture, HDFS & MapReduce
  • Unix Shell & Apache Pig Installation
  • HIVE Installation & User-Defined Functions
  • SQOOP & Hbase Installation

Upcoming Class

7 days 21 Jun 2024


  • Features of Python
  • Python Editors and IDEs
  • Data types and Variables
  • Python File Operation

Upcoming Class

-0 day 14 Jun 2024

Artificial Intelligence

  • Components of AI
  • Categories of Machine Learning
  • Recurrent Neural Networks
  • Recurrent Neural Networks

Upcoming Class

15 days 29 Jun 2024

Machine Learning

  • Introduction to Machine Learning & Python
  • Machine Learning: Supervised Learning
  • Machine Learning: Unsupervised Learning

Upcoming Class

28 days 12 Jul 2024


  • Introduction to Tableau Desktop
  • Data Transformation Methods
  • Configuring tableau server
  • Integration with R & Hadoop

Upcoming Class

7 days 21 Jun 2024