Relational Database Management System Mcqs

Page No. 50

A logical counter is _________ after a new timestamp has been assigned


a Incremented


bDecremented


cDoubled


d Remains the same


View Answer Incremented

Which of the following cannot be used to implement a timestamp


aSystem clock


bLogical counter


c External time counter


dNone of the mentioned



State true or false: We determine the serializability order of validation protocol by the validation ordering technique


aTrue


bFalse


ceither ture or false


dnone of these


View Answer False

State true or false: Locking and timestamp ordering force a wait or rollback whenever a conflict is detected.


aTrue


bFalse


ceither ture or false


dnone of these


View Answer True

Which of the following timestamps is used to record the time when a database has completed its write operation?


aStart(i)


bValidation(i)


cFinish(i)


d Write(i)


View Answer Finish(i)

Which of the following timestamps is used to record the time when a transaction has finished its read phase?


aStart(i)


bValidation(i)


cFinish(i)


dWrite(i)


View Answer Validation(i)

Which of the following timestamp is used to record the time at which the transaction started execution?


aStart(i)


bValidation(i)


cFinish(i)


drite(i)


View Answer Start(i)

Read only operations omit the _______ phase


aRead phase


b Validation phase


cWrite phase


dNone of the mentioned


View Answer Write phase

During the _______ phase, the local variables that hold the write operations are copied to the database


aRead phase


bValidation phase


cWrite phase


dNone of the mentioned


View Answer Write phase

During the _________ phase the validation test is applied to the transaction


a Read phase


bValidation phase


cWrite phase


dNone of the mentioned


View Answer Validation phase

Goto Page No.

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