MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
THE_OPERATING_SYSTEM_RESERVES_SPACE_ON_DISK_FOR_STORING_VIRTUAL-MEMORY_PAGES_THAT_ARE_NOT_CURRENTLY_IN_MAIN_MEMORY;_THIS_SPACE_IS_CALLED?$ |
| A. | Latches |
| B. | Swap Space |
| C. | Dirty Block |
| D. | None of the mentioned |
| Answer» C. Dirty Block | |
| 2. |
THE____________________CONTAINS_A_LIST_OF_BLOCKS_THAT_HAVE_BEEN_UPDATED_IN_THE_DATABASE_BUFFER.?$ |
| A. | Latches |
| B. | Swap Space |
| C. | Dirty Block |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 3. |
Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This i? |
| A. | Latches |
| B. | Swap Space |
| C. | Dirty Block |
| D. | None of the mentioned |
| Answer» B. Swap Space | |
| 4. |
The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed. |
| A. | Force |
| B. | No-force |
| C. | Steal |
| D. | No-steal |
| Answer» D. No-steal | |
| 5. |
______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks. |
| A. | Force |
| B. | No-force |
| C. | Steal |
| D. | No-steal |
| Answer» C. Steal | |
| 6. |
The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk. |
| A. | Force |
| B. | No-force |
| C. | Steal |
| D. | No-steal |
| Answer» C. Steal | |
| 7. |
Writing the buffered log to __________ is sometimes referred to as a log force. |
| A. | Memory |
| B. | Backup |
| C. | Redo memory |
| D. | Disk |
| Answer» E. | |
| 8. |
Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is |
| A. | Read-write logging |
| B. | Read-ahead logging |
| C. | Write-ahead logging |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 9. |
The order of log records in the stable storage ____________ as the order in which they were written to the log buffer. |
| A. | Must be exactly the same |
| B. | Can be different |
| C. | Is opposite |
| D. | Can be partially same |
| Answer» B. Can be different | |
| 10. |
In order to reduce the overhead in retrieving the records from the storage space we use |
| A. | Logs |
| B. | Log buffer |
| C. | Medieval space |
| D. | Lower records |
| Answer» C. Medieval space | |