Similar Collections

.

questions

Title
A data dictionary is a special file that contains
Relational schemas and other metadata about relations are stored in a structure called the ____________
__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth
________ is the smallest unit of allocation in an Oracle database
An Oracle __________ is a set of tables and views that are used as a read-only reference about the database
A data dictionary is created when a __________ created
An Oracle object type has two parts the _________ and__________
The _______ is that part of main memory available for storage of copies of disk blocks
A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by
The subsystem responsible for the allocation of buffer space is called the ___________
In the buffer where there is no space for another block, the bllock can be inserted using
A block that is not allowed to be written back to disk is said to be ______________
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
The frequently used buffer replacement strategy is
In case the buffer manager do not write the blocks properly then the buffer manager uses
The technique where the blocks which have been used are replaced is called
___________________ frees the space occupied by a block as soon as the final tuple of that block has been processed
total questions: 197

Questions

197

Views

2100

Best Answers

299

Points

5