Question
a.
Replacement strategy
b.
Forced strategy
c.
Toss immediate strategy
d.
Most recently used
Posted under Storage and File Structures DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. ___________________ frees the space occupied by a block as soon as the final tuple of that block has been processed.
Similar Questions
Discover Related MCQs
Q. The technique where the blocks which have been used are replaced is called
View solution
Q. In case the buffer manager do not write the blocks properly then the buffer manager uses
View solution
Q. The frequently used buffer replacement strategy is
View solution
Q. 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
View solution
Q. A block that is not allowed to be written back to disk is said to be ______________
View solution
Q. In the buffer where there is no space for another block, the bllock can be inserted using
View solution
Q. The subsystem responsible for the allocation of buffer space is called the ___________
View solution
Q. A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by
View solution
Q. The _______ is that part of main memory available for storage of copies of disk blocks.
View solution
Q. An Oracle object type has two parts the _________ and__________
View solution
Q. A data dictionary is created when a __________ created.
View solution
Q. An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
View solution
Q. ________ is the smallest unit of allocation in an Oracle database.
View solution
Q. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.
View solution
Q. Relational schemas and other metadata about relations are stored in a structure called the ____________
View solution
Q. A data dictionary is a special file that contains?
View solution
Q. The information about data in a database is called _______
View solution
Q. Which of these data models is an extension of relational data model?
View solution
Q. Which of these is not a feature of Hierarchical model?
View solution
Q. Which of the following is not true of the traditional approach to information processing
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
.png)
