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