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

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. We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________

  • (A) Diamond , diamond
  • (B) Rectangle, diamond
  • (C) Rectangle, rectangle
  • (D) Diamond, rectangle

A

Admin • 833.24K Points
Coach

Q. An entity set that does not have sufficient attributes to form a primary key is termed a __________

  • (A) Strong entity set
  • (B) Variant set
  • (C) Weak entity set
  • (D) Variable set

A

Admin • 833.24K Points
Coach

Q. For a weak entity set to be meaningful, it must be associated with another entity set, called the

  • (A) Identifying set
  • (B) Owner set
  • (C) Neighbour set
  • (D) Strong entity set

A

Admin • 833.24K Points
Coach

Q. If you were collecting and storing information about your music collection, an album would be considered a(n) _____

  • (A) Relation
  • (B) Entity
  • (C) Instance
  • (D) Attribute

A

Admin • 833.24K Points
Coach

Q. What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

  • (A) Relation
  • (B) Instance
  • (C) Table
  • (D) Column

A

Admin • 833.24K Points
Coach

Q. If a piece of data is stored in two places in the database, then

  • (A) Storage space is wasted
  • (B) Changing the data in one spot will cause data inconsistency
  • (C) In can be more easily accessed
  • (D) Storage space is wasted & Changing the data in one spot will cause data inconsistency

A

Admin • 833.24K Points
Coach

Q. An audit trail ___________

  • (A) Is used to make backup copies
  • (B) Is the recorded history of operations performed on a file
  • (C) Can be used to restore lost information
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. Large collection of files are called ____________

  • (A) Fields
  • (B) Records
  • (C) Database
  • (D) Sectors

A

Admin • 833.24K Points
Coach

Q. Which of the following hardware component is the most important to the operation of a database management system?

  • (A) High resolution video display
  • (B) Printer
  • (C) High speed, large capacity disk
  • (D) Mouse

A

Admin • 833.24K Points
Coach

Q. Which of the following is not true of the traditional approach to information processing

  • (A) There is common sharing of data among the various applications
  • (B) It is file oriented
  • (C) Programs are dependent on the file
  • (D) It is inflexible

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.