Database Management Systems Mcqs

Page No. 66

The _____________ ensures that any conflicting read and write operations are executed in timestamp order.


aTimestamp-ordering protocol


bTimestamp protocol


cW-timestamp


dR-timestamp



____________ denotes the largest timestamp of any transaction that executed write(Q) successfully.


aW-timestamp(Q)


bR-timestamp(Q)


cRW-timestamp(Q)


dWR-timestamp(Q)


View Answer W-timestamp(Q)

If a node is locked in ______________ the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.


aIntention lock modes


bshared and intention-exclusive (SIX) mode


cIntention-exclusive (IX) mode


dIntention-exclusive (IX) mode



If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.


aIntention lock modes


bIntention-shared-exclusive mode


cIntention-exclusive (IX) mode


dIntention-shared (IS) mode



If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.


aIntention lock modes


bIntention-shared-exclusive mode


cIntention-exclusive (IX) mode


dIntention-shared (IS) mode


View Answer Intention lock modes

If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called


aIntention lock modes


bExplicit lock


cImplicit lock


dExclusive lock


View Answer Intention lock modes

In a database the file is contained in ________


aEntire database


bTwo area


cOne area


dmore than one area


View Answer One area

In a granularity hierarchy the highest level represents the


aEntire database


bArea


cFile


dRecord


View Answer Entire database

__________ rollback requires the system to maintain additional information about the state of all the running transactions.


aTotal


bPartial


cTime


dCommit


View Answer Partial

Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is


aHow long the transaction has computed, and how much longer the transaction will compute before it completes its designated task


bHow many data items the transaction has used


cHow many more data items the transaction needs for it to complete


dAll of the mentioned


View Answer All of the mentioned

Goto Page No.

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