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

Q. Which of the following hardware component is the most important to the operation of database management system?

View solution

Q. Large collection of files are called ____________

View solution

Q. An audit trail ___________

View solution