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

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 redundancy and inconsistency
  • (B) difficulty in accessing data
  • (C) data isolation
  • (D) all of the above

A

Admin • 833.24K Points
Coach

Q. In an Entity-Relationship Diagram Rectangles represents

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

A

Admin • 833.24K Points
Coach

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

  • (A) transaction manager
  • (B) logical manager
  • (C) buffer manager
  • (D) file 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 of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is not an Schema?

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

A

Admin • 833.24K Points
Coach

Q. Which of the following is Database Language?

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

A

Admin • 833.24K Points
Coach

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

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

A

Admin • 833.24K Points
Coach

Q. Which of the following represents a relationship among a set of values.

  • (A) a row
  • (B) a table
  • (C) a field
  • (D) a column

A

Admin • 833.24K Points
Coach

Q. Column header is refer as

  • (A) table
  • (B) relation
  • (C) attributes
  • (D) domain

A

Admin • 833.24K Points
Coach

Q. A Relation is a

  • (A) subset of a cartesian product of a list of attributes
  • (B) subset of a cartesian product of a list of domains
  • (C) subset of a cartesian product of a list of tuple
  • (D) subset of a cartesian product of a list of relations

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.