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. |
___________STARTS_FROM_A_POSITION_DETERMINED_DURING_ANALYSIS,_AND_PERFORMS_A_REDO,_REPEATING_HISTORY,_TO_BRING_THE_DATABASE_TO_A_STATE_IT_WAS_IN_BEFORE_THE_CRASH.?$ |
| A. | Analysis pass |
| B. | Redo pass |
| C. | Undo pass |
| D. | None of the mentioned |
| Answer» C. Undo pass | |
| 2. |
_______________rolls_back_all_transactions_that_were_incomplete_at_the_time_of_crash.$ |
| A. | Analysis pass |
| B. | Redo pass |
| C. | Undo pass |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 3. |
___________ determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start? |
| A. | Analysis pass |
| B. | Redo pass |
| C. | Undo pass |
| D. | None of the mentioned |
| Answer» B. Redo pass | |
| 4. |
The __________________ contains a list of pages that have been updated in the database buffer. |
| A. | Dirty page table |
| B. | Page table |
| C. | Dirty redo |
| D. | All of the mentioned |
| Answer» B. Page table | |
| 5. |
There are special redo-only log records generated during transaction rollback, called _________ in ARIES. |
| A. | Compensation log records |
| B. | Read log records |
| C. | Page log records |
| D. | Redo log records |
| Answer» B. Read log records | |
| 6. |
Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page. |
| A. | LSN |
| B. | ReadLSN |
| C. | PageLSN |
| D. | RedoLSN |
| Answer» D. RedoLSN | |
| 7. |
__________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk. |
| A. | Fuzzy logic |
| B. | Checkpoints |
| C. | Fuzzy-checkpoint |
| D. | Logical checkpoint |
| Answer» D. Logical checkpoint | |
| 8. |
______________ is used to minimize unnecessary redos during recovery. |
| A. | Dirty page table |
| B. | Page table |
| C. | Dirty redo |
| D. | All of the mentioned |
| Answer» B. Page table | |
| 9. |
ARIES supports ___________ operations, which are physical in that the affected page is physically identified, but can be logical within the page. |
| A. | Physiological redo |
| B. | Physiological undo |
| C. | Logical redo |
| D. | Logical undo |
| Answer» B. Physiological undo | |
| 10. |
ARIES uses a ___________ to identify log records, and stores it in database pages. |
| A. | Log sequence number |
| B. | Log number |
| C. | Lock number |
| D. | Sequence |
| Answer» C. Lock number | |