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