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.