MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject 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 | |
| 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 | |
| 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 | |
| 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 | |