Transaction Management Multiple Choice Questions (MCQ) 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