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

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. A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

  • (A) Tablespace
  • (B) Segments
  • (C) Extents
  • (D) Blocks

A

Admin • 833.24K Points
Coach

Q. A tablespace is further broken down into ________

  • (A) Tablespace
  • (B) Segments
  • (C) Extents
  • (D) Blocks

A

Admin • 833.24K Points
Coach

Q. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

  • (A) Tablespace
  • (B) Segment
  • (C) Extent
  • (D) Block

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

  • (A) Instance
  • (B) Segment
  • (C) Database
  • (D) Dictionary

A

Admin • 833.24K Points
Coach

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

  • (A) Instance and body
  • (B) Segment and blocks
  • (C) Specification and body
  • (D) Body and segment

A

Admin • 833.24K Points
Coach

Q. A(n) _________ can be used to preserve the integrity of a document or a message.

  • (A) Message digest
  • (B) Message summary
  • (C) Encrypted message
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. A hash function must meet ________ criteriA:)

  • (A) Two
  • (B) Three
  • (C) Four
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. What is the main limitation of Hierarchical Databases?

  • (A) Limited capacity (unable to hold much datA:)
  • (B) Limited flexibility in accessing data
  • (C) Overhead associated with maintaining indexes
  • (D) The performance of the database is poor

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.