Database Management Systems Mcqs

Page No. 70

Shadow paging has


aneither redo nor undo


bredo but no undo


cno undo


dno redo


View Answer no redo

Immediate database modification technique uses


aBoth undo and redo


bUndo but no redo


cRedo but no undo


dNeither undo nor redo


View Answer Both undo and redo

An operation is said to be __________ if executing it several times in a row gives the same result as executing it once.


aIdempotent


bChanged


cRepetitive


dAll of the above


View Answer Idempotent

To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.


aPersistent


bResistant


cConsistent


dNone of the mentioned


View Answer Consistent

Redo operations are performed exclusively using


aLogical logging


bPhysical logging


cPhysical log records


dBoth Physical logging and Physical log records



Which of the following is used for undo operations alone?


aLogical logging


bPhysical logging


cPhysical log records


dPhysical logging and Physical log records


View Answer Logical logging

Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called


aLogical operation


bRedo operation


cLogical undo operation


dUndo operation


View Answer Logical operation

Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.


aHigher-level lock


bLower-level lock


cRead only lock


dRead write


View Answer Higher-level lock

______________ rolls back all transactions that were incomplete at the time of crash.


aAnalysis pass


bRedo pass


cUndo pass


dNone of the mentioned


View Answer Undo pass

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


aAnalysis pass


bRedo pass


cUndo pass


dNone of the mentioned


View Answer Redo pass

Goto Page No.

Page 70 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