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

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. If a piece of data is stored in two places in the database, then

  • (A) in can be more easily accessed
  • (B) both storage space is wasted and changing the data in one spot will cause data inconsistency
  • (C) storage space is wasted
  • (D) changing the data in one spot will cause data inconsistency

A

Admin • 833.24K Points
Coach

Q. Which of the following is a problem of file management system?

  • (A) data redundancy and program dependence
  • (B) all of the options
  • (C) difficult to update
  • (D) lack of data independence

A

Admin • 833.24K Points
Coach

Q. Which of the following is not an advantage of the database approach

  • (A) elimination of data redundancy
  • (B) ability of associate deleted data
  • (C) increased security and program/data independence
  • (D) all of the above

A

Admin • 833.24K Points
Coach

Q. An audit trail

  • (A) none of the options
  • (B) is the recorded history of operations performed on a file
  • (C) is used to make backup copies
  • (D) can be used to restore lost information

A

Admin • 833.24K Points
Coach

Q. One approach to standardization storing of data?

  • (A) codasyl specification
  • (B) none of the options
  • (C) mis
  • (D) structured programming

A

Admin • 833.24K Points
Coach

Q. Report generators are used to

  • (A) store data input by a user
  • (B) answer queries
  • (C) both retrieve information from files and answer queries
  • (D) retrieve information from files

A

Admin • 833.24K Points
Coach

Q. Which of the following is true of a network structure?

  • (A) it will be dominant data base of the future
  • (B) it allows a many-to-many relationship
  • (C) it is a physical representation of the data
  • (D) it is conceptually simple

A

Admin • 833.24K Points
Coach

Q. In a large DBMS

  • (A) none of the options
  • (B) each user can "see" only a small part of the entire database
  • (C) each subschema contains every field in the logical schema
  • (D) each user can access every subschema

A

Admin • 833.24K Points
Coach

Q. A Database Management System (DBMS) is

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

A

Admin • 833.24K Points
Coach

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

  • (A) physical level
  • (B) critical level
  • (C) logical level
  • (D) view 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.