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