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

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. Disadvantages of File systems to store data is:

  • (A) data isolation
  • (B) data redundancy and inconsistency
  • (C) difficulty in accessing data
  • (D) all options are correct

A

Admin • 833.24K Points
Coach

Q. In an Entity Relationship Diagram Rectangles represents

  • (A) tables
  • (B) attributes
  • (C) database
  • (D) entity sets

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a Storage Manager Component?

  • (A) transaction manager
  • (B) logical manager
  • (C) file manager
  • (D) buffer manager

A

Admin • 833.24K Points
Coach

Q. Data Manipulation Language enables users to

  • (A) retrieval of information stored in database
  • (B) insertion of new information into the database
  • (C) deletion of information from the database
  • (D) all the options are correct

A

Admin • 833.24K Points
Coach

Q. Which of the following is not an Schema?

  • (A) logical schema
  • (B) physical schema
  • (C) database schema
  • (D) critical schema

A

Admin • 833.24K Points
Coach

Q. Which of the following is Database Language?

  • (A) data definition language
  • (B) data manipulation language
  • (C) data query language
  • (D) all of the options

A

Admin • 833.24K Points
Coach

Q. Which of the following in not a function of DBA?

  • (A) network maintenance
  • (B) schema definition
  • (C) authorization for data access
  • (D) routine maintenance

A

Admin • 833.24K Points
Coach

Q. Which of the following is a Data Model?

  • (A) entity relationship model
  • (B) object based data model
  • (C) all of the options are correct
  • (D) relational data model

A

Admin • 833.24K Points
Coach

Q. A Database Management System (DBMS) is

  • (A) collection of interrelated data
  • (B) collection of data describing one particular enterprise
  • (C) all of the options
  • (D) collection of programs to access data

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a level of data abstraction?

  • (A) physical level
  • (B) view level
  • (C) critical level
  • (D) logical level

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.