What is the role of a transaction manager in a distributed database?
Practice Questions
Q1
What is the role of a transaction manager in a distributed database?
To manage data replication
To ensure ACID properties across distributed transactions
To handle user authentication
To optimize query performance
Questions & Step-by-Step Solutions
What is the role of a transaction manager in a distributed database?
Correct Answer: Transaction manager ka role hai ACID properties ko maintain karna.
Step 1: Understand that a distributed database is a system where data is stored across multiple locations or servers.
Step 2: Know that a transaction is a sequence of operations that are treated as a single unit of work.
Step 3: Learn about ACID properties: Atomicity (all or nothing), Consistency (data remains valid), Isolation (transactions do not interfere), and Durability (once completed, transactions are permanent).
Step 4: Recognize that the transaction manager is responsible for making sure these ACID properties are followed when transactions happen across different locations.
Step 5: Understand that the transaction manager coordinates the actions of different servers to ensure that all parts of a transaction are completed successfully or none at all.
