DBMS-Transaction Processing and Concurrency Control - Practice Questions

Question 1

the serial execution always leaves the database in a consistent state although different results could be produced depending on the order of execution.

Accepted Answer

Question 2

Which of the following is validation-based concurrency control?

Accepted Answer

Question 3

Which of the following ensures the atomicity of a transaction ?

Accepted Answer

Question 4

A transaction is said to be in committed state if it has partially committed, and it can be ensured that it will never be aborted.

Accepted Answer

Question 5

Which of the following is not a deadlock handling strategy ?

Accepted Answer

Question 6

In binary locking, there are

Accepted Answer

Question 7

A lost update problem occurs when two transctions that access the same database items have their operations in a way that makes the value of some database item incorrect.

Accepted Answer

Question 8

Cascading rollbacks are not desirable.

Accepted Answer

Question 9

The size of the locked item determines the granularity of the lock.

Accepted Answer

Question 10

Which of the following is the ability of a DBMS to manage the various transactions that occur within the system ?

Accepted Answer