Which DBMS component is responsible for managing concurrent transactions and maintaining consistency?
Options
-
A.
Query processor
-
B.
Transaction manager
-
C.
Data dictionary
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
Transaction manager
Detailed Explanation
- Transaction manager: Coordinates transaction execution and helps maintain database consistency.
- It works with concurrency-control and recovery mechanisms.
- Query processor: Parses, optimizes and executes database queries.
OOps! You are currently offline.