Operating System Mcqs

Page No. 17

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?
I) 2-phase locking
II) Timestamp ordering


aI only


bII only


cBoth I and II


dNeither I nor II


View Answer II only

The shrinking phase is a phase in which?


aA transaction may obtain locks, but does not release any


bA transaction may obtain locks, and releases a few or all of them


cA transaction may release locks, but does not obtain any new locks


dA transaction may release locks, and does obtain new locks



The growing phase is a phase in which?


aA transaction may obtain locks, but does not release any


bA transaction may obtain locks, and releases a few or all of them


cA transaction may release locks, but does not obtain any new locks


dA transaction may release locks, and does obtain new locks



The two phase locking protocol consists of ____________


agrowing & shrinking phase


bshrinking & creation phase


ccreation & growing phase


ddestruction & creation phase



A locking protocol is one that ____________


agoverns how locks are acquired


bgoverns how locks are released


cgoverns how locks are acquired and released


dnone of the mentioned



Serializable schedules are ones where ____________


aconcurrent execution of transactions is equivalent to the transactions executed serially


bthe transactions can be carried out one after the other


ca valid result occurs after execution transactions


dnone of the mentioned



Consider a transaction T1 that committed prior to checkpoint. The <T1 commits> record appears in the log before the <checkpoint> record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time ____________


aThere is a need to perform an undo operation on T1


bThere is a need to perform a redo operation on T1


cThere is no need to perform an undo and redo operation on T1


dAll of the mentioned



The system periodically performs checkpoints that consists of the following operation(s) ____________


aPutting all the log records currently in main memory onto stable storage


bputting all modified data residing in main memory onto stable storage


cputting a log record onto stable storage


dall of the mentioned


View Answer all of the mentioned

The undo and redo operations must be _________ to guarantee correct behaviour, even if a failure occurs during recovery process.


aidempotent


beasy


cprotected


dall of the mentioned


View Answer idempotent

An actual update is not allowed to a data item ____________


abefore the corresponding log record is written out to stable storage


bafter the corresponding log record is written out to stable storage


cuntil the whole log record has been checked for inconsistencies


dall of the mentioned



Goto Page No.

Page 17 of 108

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