Master In Computer Science

Database Systems MCQs

CS: Database Systems MCQs - Subtopic

Transaction Isolation and Atomicity MCQ with Answers

Transaction Isolation and Atomicity Multiple Choice Questions (MCQ) to practice transaction isolation and atomicity quiz answers PDF, transaction isolation and atomicity worksheets for online degrees. Solve database transactions Multiple Choice Questions and Answers (MCQs), "Transaction Isolation and Atomicity Quiz Questions" and answers for associates in computer science. Learn types of storage structure, transaction isolation levels, storage and file structure, transaction model test prep for computer information science.

"A single transaction failure may result into a set of transaction rollbacks, is known to be" Multiple Choice Questions (MCQ) on transaction isolation and atomicity with choices iterated rollback, cascadeless rollback, cascading rollback, and serial rollback for associates in computer science. Solve transaction isolation and atomicity quiz questions for merit scholarship test and certificate programs for free online classes.

MCQs on Transaction Isolation and Atomicity

1.

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

Iterated rollback
Cascadeless rollback
Cascading rollback
Serial rollback

2.

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

Response time
Utilization
Concurrency time
Throughput

3.

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

Average response time
Average access time
Average execution time
Average utilize time

4.

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

Topological order
Serializability order
Precedence order
Conflict serializability order

5.

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

Partial schedule
Dependent schedule
Serialized schedule
Unserialized schedule