MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Operating System knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The shrinking phase is a phase in which? |
| A. | A transaction may obtain locks, but does not release any |
| B. | A transaction may obtain locks, and releases a few or all of them |
| C. | A transaction may release locks, but does not obtain any new locks |
| D. | A transaction may release locks, and does obtain new locks |
| Answer» D. A transaction may release locks, and does obtain new locks | |
| 2. |
The two phase locking protocol consists of ____________ |
| A. | growing & shrinking phase |
| B. | shrinking & creation phase |
| C. | creation & growing phase |
| D. | destruction & creation phase |
| Answer» B. shrinking & creation phase | |
| 3. |
A locking protocol is one that ____________ |
| A. | governs how locks are acquired |
| B. | governs how locks are released |
| C. | governs how locks are acquired and released |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 4. |
Serializable schedules are ones where ____________ |
| A. | concurrent execution of transactions is equivalent to the transactions executed serially |
| B. | the transactions can be carried out one after the other |
| C. | a valid result occurs after execution transactions |
| D. | none of the mentioned |
| Answer» B. the transactions can be carried out one after the other | |
| 5. |
Consider a transaction T1 that committed prior to checkpoint. The <T1 commits> record appears in the log before the <checkpoint> record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time ____________ |
| A. | There is a need to perform an undo operation on T1 |
| B. | There is a need to perform a redo operation on T1 |
| C. | There is no need to perform an undo and redo operation on T1 |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 6. |
An actual update is not allowed to a data item ____________ |
| A. | before the corresponding log record is written out to stable storage |
| B. | after the corresponding log record is written out to stable storage |
| C. | until the whole log record has been checked for inconsistencies |
| D. | all of the mentioned |
| Answer» B. after the corresponding log record is written out to stable storage | |
| 7. |
In the write ahead logging a _____________ is maintained. |
| A. | a memory |
| B. | a system |
| C. | a disk |
| D. | a log record |
| Answer» E. | |
| 8. |
Write ahead logging is a way ____________ |
| A. | to ensure atomicity |
| B. | to keep data consistent |
| C. | that records data on stable storage |
| D. | all of the mentioned |
| Answer» E. | |
| 9. |
A collection of instructions that performs a single logical function is called ____________ |
| A. | transaction |
| B. | operation |
| C. | function |
| D. | all of the mentioned |
| Answer» B. operation | |