Transaction Isolation and Atomicity Multiple Choice Questions (MCQ) PDF Download

MCQ 1: A single transaction failure may result into a set of transaction rollbacks, is known to be

1. Iterated rollback
2. Cascadeless rollback
3. Cascading rollback
4. Serial rollback

MCQ 2: In a given amount of time the number of transactions that can be executed is known to be the

1. Response time
2. Utilization
3. Concurrency time
4. Throughput

MCQ 3: The time for a transaction to be completely executed after its submission is known to be its

1. Average response time
2. Average access time
3. Average execution time
4. Average utilize time

MCQ 4: By finding a linear order consistent with the partial order in the precedence graph, we can obtain the

1. Topological order
2. Serializability order
3. Precedence order
4. Conflict serializability order

MCQ 5: If an schedule doesn't include commit or abort operation, it is defined to be

1. Partial schedule
2. Dependent schedule
3. Serialized schedule
4. Unserialized schedule