MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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. |
Which of the following transactions can multiversion two phase locking protocol not differentiate. |
| A. | tRead only transactions |
| B. | tUpdate transactions |
| C. | tAll of the mentioned |
| D. | tDouble operator transactions |
| Answer» E. | |
| 2. |
In ________ no two aborts occur unless two concurrent transactions update the same data item. |
| A. | tMultiversion scheme |
| B. | tTimestamp protocol |
| C. | tLock based protocol |
| D. | tSnapshot isolation |
| Answer» E. | |
| 3. |
State true or false: Snapshot isolation has low overhead |
| A. | tTrue |
| B. | tFalse |
| Answer» B. tFalse | |
| 4. |
In _______ schemes, each write operation creates a new version of Q |
| A. | tMultiversion |
| B. | tSnapshot isolation |
| C. | tLock based |
| D. | tTimestamp |
| Answer» B. tSnapshot isolation | |