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

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 property (or set of properties) that uniquely defines each row in a table is called the:

  • (A) Identifier
  • (B) Index
  • (C) Primary key
  • (D) Symmetric key

A

Admin • 833.24K Points
Coach

Q. The separation of the data definition from the program is known as:

  • (A) Data dictionary
  • (B) Data independence
  • (C) Data integrity
  • (D) Referential integrity

A

Admin • 833.24K Points
Coach

Q. The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?

  • (A) Hierarchical
  • (B) Network
  • (C) Object oriented
  • (D) Relational

A

Admin • 833.24K Points
Coach

Q. The database design that consists of multiple tables that are linked together through matching data stored in each table is called

  • (A) Hierarchical database
  • (B) Network database
  • (C) Object oriented database
  • (D) Relational database

A

Admin • 833.24K Points
Coach

Q. The association role defines:

  • (A) How tables are related in the database
  • (B) The relationship between the class diagram and the tables in the database
  • (C) The tables that each attribute is contained
  • (D) Which attribute is the table’s primary key

A

Admin • 833.24K Points
Coach

Q. The purpose of an N-Ary association is:

  • (A) To capture a parent-child relationship
  • (B) To deal with one to many relationships
  • (C) To deal with relationships that involve more than two tables
  • (D) To represent an inheritance relationship

A

Admin • 833.24K Points
Coach

Q. In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

  • (A) Clustered index
  • (B) Structured index
  • (C) Unstructured index
  • (D) Nonclustered index

A

Admin • 833.24K Points
Coach

Q. Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

  • (A) Nonclustered
  • (B) Secondary
  • (C) All of the mentioned
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.

  • (A) Index entry
  • (B) Index hash
  • (C) Index cluster
  • (D) Index map

A

Admin • 833.24K Points
Coach

Q. In a _______ clustering index, the index record contains the search-key value and a
pointer to the first data record with that search-key value and the rest of the records will be in
the sequential pointers.

  • (A) Dense
  • (B) Sparse
  • (C) Straight
  • (D) Continuous

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.