Database Management Systems Mcqs

Page No. 68

All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.


aScheduler


bDBMS


cLock manager


dLocking agent


View Answer Lock manager

Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other


aConcurrency


bDeadlock


cBackup


dRecovery


View Answer Concurrency

If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.


aExplicit lock in exclusive mode


bImplicit lock in shared mode


cExplicit lock in shared mode


dImplicit lock in exclusive mode



Which of the following is the block that is not permitted to be written back to the disk?


aDead code


bRead only


cPinned


dZapped


View Answer Pinned

Which of the following protocols ensures conflict serializability and safety from deadlocks?


aTwo-phase locking protocol


bTime-stamp ordering protocol


cGraph based protocol


dNone of the mentioned



Which of the following are introduced to reduce the overheads caused by the log-based recovery?


aCheckpoints


bIndices


cDeadlocks


dLocks


View Answer Checkpoints

A lock that allows concurrent transactions to access different rows of the same table is known as a


aDatabase-level lock


bTable-level lock


cPage-level lock


dRow-level lock


View Answer Row-level lock

In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?


aTriggers


bPointers


cLocks


dCursors


View Answer Locks

If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is


aOne Safe


bTwo Safe


cTwo-very Safe


dVery Safe


View Answer Two Safe

A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is


aOne Safe


bTwo Safe


cTwo-very Safe


dVery Safe


View Answer Two-very Safe

Goto Page No.

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