Database Concurrency and Transactions Quiz

Which level of locking provides the highest degree of concurrency in a relational data base?

• Page

• Table

• Row

• None.

Which one of the following is NOT a part of the ACID properties of database transactions?

• Atomicity

• Isolation

• Consistency

• Deadlock Freedom

Which of the following concurrency control protocol ensures both conflict serializability and free from deadlock?

• Two Phase Locking

• Strict Two Phase Locking

• Timestamp Ordering

• None

Which of the following is correct with respect to Two phase commit protocol?

• Ensures Serializability

• Prevents Deadlock

• Detects Deadlock

• Avoid Deadlock

Which of the following is correct?

(i)   Two phase locking is an optimistic protocol. (Ii). Two phase locking is pessimistic protocol      (iii). Time stamping is an optimistic protocol.      (iv). Time stamping is pessimistic protocol. 

• (ii) & (iv)

• (i) & (iii)

• (i) & (iv)

• (ii) & (iii)

During simultaneous execution, each operation should be performed interleaved with the others, ensuring that there is no interference with the other operations. This maintains ________ in database.

• Consistency

• Durability

• Concurrency

• Atomicity

What is the Lost Update Problem also known as?

• W-W Conflict

• W-R Conflict

• R-R Conflict

• None

Assume transaction A holds a share lock R. If a transaction B also requests for a shared lock on R.

• It will result in a deadlock situation.

• It will immediately be granted.

• It will immediately be rejected.

• It will be granted as soon as it is released by A.

• None of the above

Which of the following locks the item from access of any type?

• Implicit lock

• Explicit lock

• Exclusive lock

• Shared lock

Which of the following is a concurrency problem?

• Temporary Update Problem

• Incorrect Summary Problem

• Lost Update Problem

• All of the above