Database Management System (DBMS) MCQs with answers Page - 72

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. During recovery from a failure

  • (A) each pair of physical block is examined
  • (B) specified pair of physical block is examined
  • (C) first pair of physical block is examined
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. A magneto-optic disk is :

  • (A) primary storage
  • (B) secondary storage
  • (C) tertiary storage
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. The replacement of a bad block generally is not totally automatic because

  • (A) data in bad block cannot be replaced
  • (B) data in bad block is usually lost
  • (C) bad block does not contain any data
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. is a contiguous group of

  • (A) instance
  • (B) segment
  • (C) database
  • (D) dictionary

A

Admin • 833.24K Points
Coach

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

  • (A) database
  • (B) instance
  • (C) tablespace
  • (D) database block

A

Admin • 833.24K Points
Coach

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

  • (A) database dictionary
  • (B) dictionary table
  • (C) data dictionary
  • (D) dictionary

A

Admin • 833.24K Points
Coach

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

  • (A) buffer
  • (B) catalog
  • (C) storage
  • (D) secondary storage

A

Admin • 833.24K Points
Coach

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

  • (A) buffer
  • (B) catalog
  • (C) storage
  • (D) secondary storage

A

Admin • 833.24K Points
Coach

Q. The subsystem responsible for the allocation of buffer space is called the

  • (A) buffer
  • (B) buffer manager
  • (C) storage
  • (D) secondary storage

A

Admin • 833.24K Points
Coach

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

  • (A) pinned block strategy
  • (B) forced output block
  • (C) buffer replacement strategy
  • (D) all of the mentioned

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.