Relational Database Management System Mcqs

Page No. 51

During __________ phase, the system reads data and stores them in variables local to the transaction.


aRead phase


bValidation phase


c Write phase


dNone of the mentioned


View Answer Read phase

The _________ requires each transaction executes in two or three different phases in its lifetime


a Validation protocol


bTimestamp protocol


cDeadlock protocol


dView protocol



Which of the following transactions can multiversion two phase locking protocol not differentiate.


aRead only transactions


bUpdate transactions


cAll of the mentioned


dDouble operator transactions



In ________ no two aborts occur unless two concurrent transactions update the same data item.


aMultiversion scheme


bTimestamp protocol


cLock based protocol


dSnapshot isolation


View Answer Snapshot isolation

State true or false: Snapshot isolation has low overhead


aTrue


bFalse


ceaither true and false


dnone of these


View Answer True

Oracle uses __________ for the serializable isolation level


aMultiversion scheme


bTimestamp protocol


cLock based protocol


dSnapshot isolation


View Answer Snapshot isolation

The situation in which each pair of transactions has read a data written by the other, but there is no data written by the transactions is called as _______


aDeadlock


b Read skew


cDeadlock skew


dWrite skew


View Answer Write skew

Under ________ the system uses locking mechanism that applies only to updates


aFirst updater wins


bFirst committer wins


cFirst writer wins


dNone of the mentioned


View Answer First updater wins

State true or false: Snapshot isolation prevents lost updates


aTrue


bFalse


ceaither true and false


dnone of these


View Answer True

If the first update is overwritten by a second, it is called as a _______ update


aUseful


bOverlapping


cLost


dConcurrent


View Answer Lost

Goto Page No.

Page 51 of 54

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