Difficulty: Easy
Correct Answer: All of the above.
Explanation:
Introduction / Context:
The transaction manager enforces ACID properties in database systems. It coordinates logging, recovery, and isolation so that committed work is durable and concurrent activities do not corrupt data.
Given Data / Assumptions:
Concept / Approach:
A transaction manager typically maintains a transaction log, stores before/after images (or logical redo/undo information), and enforces concurrency control via locking or MVCC to achieve isolation levels.
Step-by-Step Solution:
Verification / Alternative check:
DBMS architecture references consistently list logging/recovery and locking/MVCC under the transaction subsystem.
Why Other Options Are Wrong:
Common Pitfalls:
Believing logging alone guarantees isolation; without concurrency control, anomalies can occur.
Final Answer:
All of the above.
Discussion & Comments