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