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

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. Which of these is not a feature of Hierarchical model?

  • (A) organizes the data in tree-like structure
  • (B) parent node can have any number of child nodes
  • (C) root node does not have any parent
  • (D) child node can have any number of parent nodes

A

Admin • 833.24K Points
Coach

Q. Which of these data models is an extension of the relational data model?

  • (A) object-oriented data model
  • (B) object-relational data model
  • (C) semi structured data model
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. The information about data in a database is called

  • (A) metadata
  • (B) hyper data
  • (C) tera data
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. The DBMS acts as an interface between what two components of an enterprise-class database system?

  • (A) database application and the database
  • (B) data and the database
  • (C) the user and the database application
  • (D) database application and sql

A

Admin • 833.24K Points
Coach

Q. Relational schemas and other metadata about relations are stored in a structure called the

  • (A) metadata
  • (B) catalog
  • (C) log
  • (D) data dictionary

A

Admin • 833.24K Points
Coach

Q. is the collection of memory structures and Oracle background processes that operates against an Oracle database.

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

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. In the client / server model, the database:

  • (A) is downloaded to the client upon request
  • (B) is shared by both the client and server
  • (C) resides on the client side
  • (D) resides on the server side

A

Admin • 833.24K Points
Coach

Q. A on the attribute A of relation r consists of one bitmap for each value that A can take.

  • (A) bitmap index
  • (B) bitmap
  • (C) index
  • (D) array

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.