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

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. 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. Incase the indices values are larger, index is created for these values of the index. This is called

  • (A) Pointed index
  • (B) Sequential index
  • (C) Multilevel index
  • (D) Multiple index

A

Admin • 833.24K Points
Coach

Q. A search key containing more than one attribute is referred to as a _________ search key.

  • (A) Simple
  • (B) Composite
  • (C) Compound
  • (D) Secondary

A

Admin • 833.24K Points
Coach

Q. Insertion of a large number of entries at a time into an index is referred to as __________ of the index.

  • (A) Loading
  • (B) Bulk insertion
  • (C) Bulk loading
  • (D) Increase insertion

A

Admin • 833.24K Points
Coach

Q. While inserting the record into the index, if the search-key value does not appear in the index.

  • (A) The system adds a pointer to the new record in the index entry
  • (B) The system places the record being inserted after the other records with the same searchkey values
  • (C) The system inserts an index entry with the search-key value in the index at the appropriate position
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. A collection of data designed to be used by different people is called a/an

  • (A) Organization
  • (B) Database
  • (C) Relationship
  • (D) Schema

A

Admin • 833.24K Points
Coach

Q. Which of the following is the oldest database model?

  • (A) Relational
  • (B) Deductive
  • (C) Physical
  • (D) Network

A

Admin • 833.24K Points
Coach

Q. Which of the following schemas does define a view or views of the database for particular users?

  • (A) Internal schema
  • (B) Conceptual schema
  • (C) Physical schema
  • (D) External schema

A

Admin • 833.24K Points
Coach

Q. Which of the following are the process of selecting the data storage and data access characteristics of the database?

  • (A) Logical database design
  • (B) Physical database design
  • (C) Testing and performance tuning
  • (D) Evaluation and selecting

A

Admin • 833.24K Points
Coach

Q. Which of the following terms does refer to the correctness and completeness of the data in a database?

  • (A) Data security
  • (B) Data constraint
  • (C) Data independence
  • (D) Data integrity

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.