Transaction Management Multiple Choice Questions with Answers – PDF Download

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

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

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

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

Ensuring the atomicity and durability properties is the responsibility of the

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

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