Q. ________ is the smallest unit of allocation in an Oracle database.

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. A data dictionary is created when a __________ created.

View solution

Q. An Oracle object type has two parts the _________ and__________

View solution

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

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 subsystem responsible for the allocation of buffer space is called the ___________

View solution

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

View solution

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

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. The frequently used buffer replacement strategy is

View solution

Q. In case the buffer manager do not write the blocks properly then the buffer manager uses

View solution

Q. The technique where the blocks which have been used are replaced is called

View solution

Q. ___________________ frees the space occupied by a block as soon as the final tuple of that block has been processed.

View solution