Database Management Systems Mcqs

Page No. 67

A deadlock exists in the system if and only if the wait-for graph contains a ___________


aCycle


bDirection


cBi-direction


dRotation


View Answer Cycle

The deadlock in a set of a transaction can be determined by


aRead-only graph


bWait graph


cWait-for graph


dAll of the mentioned


View Answer Read-only graph

The situation where the lock waits only for a specified amount of time for another lock to be released is


aLock timeout


bWait-wound


cTimeout


dWait


View Answer Lock timeout

When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti). This is


aWait-die


bWait-wound


cWound-wait


dWait


View Answer Wound-wait

When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj). Otherwise, Ti is rolled back (dies). This is


aWait-die


bWait-wound


cWound-wait


dWait


View Answer Wait-die

What are the ways of dealing with deadlock?


aDeadlock prevention


bDeadlock recovery


cDeadlock detection


dAll of the mentioned


View Answer All of the mentioned

The deadlock state can be changed back to stable state by using _____________ statement.


aCommit


bRollback


cSavepoint


dDeadlock


View Answer Rollback

A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.


aIdle


bWaiting


cDeadlock


dReady


View Answer Deadlock

Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?


aRecord controller


bExclusive lock


cAuthorization rule


dTwo phase lock


View Answer Two phase lock

The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.


aTable-level


bPage-level


cRow-level


dField-level


View Answer Field-level

Goto Page No.

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