Database Management Systems Mcqs

Page No. 71

___________ 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.


aAnalysis pass


bRedo pass


cUndo pass


dNone of the mentioned


View Answer Analysis pass

The __________________ contains a list of pages that have been updated in the database buffer.


aDirty page table


bPage table


cDirty redo


dAll of the mentioned


View Answer Dirty page table

There are special redo-only log records generated during transaction rollback, called _________ in ARIES.


aCompensation log records


bRead log records


cPage log records


dRedo log records



Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page.


aLSN


bReadLSN


cPageLSN


dRedoLSN


View Answer PageLSN

__________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.


aFuzzy logic


bCheckpoints


cFuzzy-checkpoint


dLogical checkpoint


View Answer Fuzzy-checkpoint

______________ is used to minimize unnecessary redos during recovery.


aDirty page table


bPage table


cDirty redo


dAll of the mentioned


View Answer Dirty page table

ARIES supports ___________ operations, which are physical in that the affected page is physically identified, but can be logical within the page.


aPhysiological redo


bPhysiological undo


cLogical redo


dLogical undo


View Answer Physiological redo

ARIES uses a ___________ to identify log records, and stores it in database pages.


aLog sequence number


bLog number


cLock number


dSequence


View Answer Log number

_________ dump schemes have been developed that allow transactions to be active while the dump is in progress.


aArchival


bFuzzy


cSQL


dAll of the mentioned


View Answer Fuzzy

________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.


aArchival


bFuzzy


cSQL


dAll of the mentioned


View Answer SQL

Goto Page No.

Page 71 of 101

Alphabetical MCQs Categories

Here below You find all kind of categories of MCQs in alphabetical order.


"Comprehensive Collection of MCQs: Alphabetically Organized by Subject"

"Discover an extensive collection of multiple-choice questions (MCQs) neatly categorized by subject from A to Z. This resource is designed for anyone eager to explore various topics in a straightforward and organized manner. Whether you're a student preparing for exams, an educator seeking supplementary materials, or simply curious about different subjects, this compilation offers a convenient way to learn and assess your knowledge. With questions arranged alphabetically, navigation is effortless, allowing you to delve into subjects of interest at your own pace. Engage, learn, and expand your understanding with this accessible and comprehensive repository of MCQs!"


BolPakistan

bolpakistan.com.pk includes Job Mcqs and Pak Mcqs is the Top Largest Mcqs Forum in World, in which you can read Mcqs of All Subjects, PPSC test preparation, FPSC, NTS and PPSC PAST PAPERS, PPSC PAST MCQS. A Collection of Repeated MCQs for JOBs seekers.

Copyright © 2024, Designed & Developed by BolPakistan