Transaction Management Multiple Choice Questions with Answers – PDF Download

MCQ 1: Detection of system failures and restoring the database to the state that existed prior to the occurrence of the failure, is known as:

1. Failure recovery
2. Failure identification
3. Failure response
4. Failure management

MCQ 2: Controlling the interaction among the concurrent transactions, is the responsibility of:

1. Concurrency-monitor manager
2. Concurrency-manipulate manager
3. Concurrency-control manager
4. Concurrency manager

MCQ 3: The concurrency-control manager and the recovery managers are part of:

1. Authorization manager
2. Transaction manager
3. Integrity manager
4. File manager

MCQ 4: Ensuring the atomicity and durability properties is the responsibility of the:

1. Recovery manager
2. Buffer manager
3. Transaction manager
4. File manager

MCQ 5: A collection of operations that performs a single logical function in a database application, is known as:

1. Transportation
2. Communication
3. Transaction
4. Concatenation