MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 16 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. | Growing phase |
| B. | Shrinking phase |
| C. | Deadlock phase |
| D. | Starved phase |
| Answer» B. Shrinking phase | |
| 2. |
The two phase locking protocol consists which of the following phases? |
| A. | Growing phase |
| B. | Shrinking phase |
| C. | More than one of the mentioned |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 3. |
If a transaction Ti may never make progress, then the transaction is said to be ____________ |
| A. | Deadlocked |
| B. | Starved |
| C. | Committed |
| D. | Rolled back |
| Answer» C. Committed | |
| 4. |
The protocol that indicates when a transaction may lock and unlock each of the data items is called as __________ |
| A. | Locking protocol |
| B. | Unlocking protocol |
| C. | Granting protocol |
| D. | Conflict protocol |
| Answer» B. Unlocking protocol | |
| 5. |
IF_A_TRANSACTION_TI_MAY_NEVER_MAKE_PROGRESS,_THEN_THE_TRANSACTION_IS_SAID_TO_BE_____________?$ |
| A. | Deadlocked |
| B. | Starved |
| C. | Committed |
| D. | Rolled back |
| Answer» C. Committed | |
| 6. |
If a transaction may obtain locks but may not release any locks then it is in _______ phase$ |
| A. | Growing phase |
| B. | Shrinking phase |
| C. | Deadlock phase |
| D. | Starved phase |
| Answer» B. Shrinking phase | |
| 7. |
The_two_phase_locking_protocol_consists_which_of_the_following_phases?$ |
| A. | Growing phase |
| B. | Shrinking phase |
| C. | More than one of the mentioned |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 8. |
If a transaction may release locks but may not obtain any locks, it is said to be in ______ phase |
| A. | Growing phase |
| B. | Shrinking phase |
| C. | Deadlock phase |
| D. | Starved phase |
| Answer» C. Deadlock phase | |
| 9. |
The protocol that indicates when a transaction may lock and unlock each of the data items is called as _________? |
| A. | Locking protocol |
| B. | Unlocking protocol |
| C. | Granting protocol |
| D. | Conflict protocol |
| Answer» B. Unlocking protocol | |
| 10. |
The situation where no transaction can proceed with normal execution is known as ________ |
| A. | Road block |
| B. | Deadlock |
| C. | Execution halt |
| D. | Abortion |
| Answer» C. Execution halt | |
| 11. |
State true or false: It is not necessarily desirable for a transaction to unlock a data item immediately after its final access |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
A transaction is made to wait until all ________ locks held on the item are released |
| A. | Compatible |
| B. | Incompatible |
| C. | Concurrent |
| D. | Equivalent |
| Answer» B. Incompatible | |
| 13. |
If a transaction can be granted a lock on an item immediately in spite of the presence of another mode, then the two modes are said to be ________ |
| A. | Concurrent |
| B. | Equivalent |
| C. | Compatible |
| D. | Executable |
| Answer» D. Executable | |
| 14. |
A transaction can proceed only after the concurrency control manager ________ the lock to the transaction |
| A. | Grants |
| B. | Requests |
| C. | Allocates |
| D. | None of the mentioned |
| Answer» B. Requests | |
| 15. |
If a transaction has obtained a ________ lock, it can both read and write on the item |
| A. | Shared mode |
| B. | Exclusive mode |
| C. | Read only mode |
| D. | Write only mode |
| Answer» C. Read only mode | |
| 16. |
If a transaction has obtained a __________ lock, it can read but cannot write on the item |
| A. | Shared mode |
| B. | Exclusive mode |
| C. | Read only mode |
| D. | Write only mode |
| Answer» B. Exclusive mode | |