Database Management Systems Mcqs

Page No. 50

___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.


aIsolation


bAtomicity


cConsistency


dDurability


View Answer Durability

Which of the following is/are false for RAW mode of FOR XML?


aXMLSCHEMA option does not returns an in-line XSD schema


bBINARY BASE32 returns the binary data in base32-encoded format


cEach row in the query result is transformed into an XML element


dNone of the mentioned



When two inputs that we desire to pipeline into the join are not already sorted it is the _____________ technique.


aHash join


bBuffer join


cdouble-pipelined hash join


ddouble-pipelined join


View Answer double-pipelined join

Tuples are generated ___________ in producer-driven pipelining, they are generated ________ on demand, in demand-driven pipelining.


aLazily, Eagerly


bEagerly, Lazily


cSlowly, Eagerly


dEagerly, Slowly


View Answer Eagerly, Lazily

The iterator maintains the __________ of its execution in between calls so that successive next() requests receive successive result tuples.


aState


bTransition


cRate


dBlock


View Answer State

Each operation in a demand-driven pipeline can be implemented as an ____ that provides the following functions: open(), next(), and close().


aDemand


bPipeline


cIterator


dAll of the mentioned


View Answer Iterator

In a _____________ operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.


aDemand-driven pipeline


bProducer-driven pipeline


cDemand pipeline


dAll of the mentioned



In a _________ the system makes repeated requests for tuples from the operation at the top of the pipeline.


aDemand-driven pipeline


bProducer-driven pipeline


cDemand pipeline


dAll of the mentioned



Pipelines can be executed in


a4


b3


c2


d5


View Answer 2

______________ allows the algorithm to execute more quickly by performing CPU activity in parallel with I/O activity.


aBuffering


bDouble buffering


cMultiple buffering


dDouble reading


View Answer Buffering

Goto Page No.

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