Database Management Systems Mcqs

Page No. 36

The frequently used buffer replacement strategy is


aMost recently used


bLeast recently used


cLongest block


dAll of the mentioned


View Answer Least recently used

There are situations in which it is necessary to write back the block to disk, even though the buffer space that it occupies is not needed. This write is called the


aPinned block strategy


bForced output block


cBuffer replacement strategy


dAll of the mentioned


View Answer Forced output block

A block that is not allowed to be written back to disk is said to be ______________


aPinned


bForced


cBuffer


dAll of the mentioned


View Answer Pinned

In the buffer where there is no space for another block, the block can be inserted using


aPinned block strategy


bForced output block


cBuffer replacement strategy


dAll of the mentioned



The subsystem responsible for the allocation of buffer space is called the ___________


aBuffer


bBuffer manager


cStorage


dSecondary storage


View Answer Buffer manager

A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by


aBuffer


bCatalog


cStorage


dSecondary storage


View Answer Buffer

The _______ is that part of main memory available for storage of copies of disk blocks.


aBuffer


bCatalog


cStorage


dSecondary storage


View Answer Buffer

An Oracle object type has two parts the _________ and__________


aInstance and body


bSegment and blocks


cSpecification and body


dBody and segment



A data dictionary is created when a __________ created.


aInstance


bSegment


cDatabase


dDictionary


View Answer Database

An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.


aDatabase dictionary


bDictionary table


cData dictionary


dDictionary


View Answer Data dictionary

Goto Page No.

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