Explore topic-wise MCQs in Rdbms.

This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.

1.

If a transaction may obtain locks but may not release any locks then it is in _______ phase

A. tGrowing phase
B. tShrinking phase
C. tDeadlock phase
D. tStarved phase
Answer» B. tShrinking phase
Discussion
2.

The two phase locking protocol consists which of the following phases?

A. tGrowing phase
B. tShrinking phase
C. tMore than one of the mentioned
D. tNone of the mentioned
Answer» D. tNone of the mentioned
Discussion
3.

If a transaction Ti may never make progress, then the transaction is said to be ____________

A. tDeadlocked
B. tStarved
C. tCommitted
D. tRolled back
Answer» C. tCommitted
Discussion
4.

The protocol that indicates when a transaction may lock and unlock each of the data items is called as __________

A. tLocking protocol
B. tUnlocking protocol
C. tGranting protocol
D. tConflict protocol
Answer» B. tUnlocking protocol
Discussion