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

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. In a __________ index, an index entry appears for only some of the search-key values.

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

A

Admin • 833.24K Points
Coach

Q. The term _______ is used to refer to a row.

  • (A) Attribute
  • (B) Tuple
  • (C) Field
  • (D) Instance

A

Admin • 833.24K Points
Coach

Q. The term attribute refers to a ___________ of a table.

  • (A) Record
  • (B) Column
  • (C) Tuple
  • (D) Key

A

Admin • 833.24K Points
Coach

Q. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

  • (A) Domain
  • (B) Relation
  • (C) Set
  • (D) Schema

A

Admin • 833.24K Points
Coach

Q. Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

  • (A) Instance, Schema
  • (B) Relation, Schema
  • (C) Relation, Domain
  • (D) Schema, Instance

A

Admin • 833.24K Points
Coach

Q. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

  • (A) Relations, Attribute
  • (B) Attributes, Relation
  • (C) Tuple, Relation
  • (D) Tuple, Attributes

A

Admin • 833.24K Points
Coach

Q. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

  • (A) Attributes of common
  • (B) Tuple of common
  • (C) Tuple of distinct
  • (D) Attributes of distinct

A

Admin • 833.24K Points
Coach

Q. A domain is atomic if elements of the domain are considered to be ____________ units.

  • (A) Different
  • (B) Indivisbile
  • (C) Constant
  • (D) Divisible

A

Admin • 833.24K Points
Coach

Q. The tuples of the relations can be of ________ order.

  • (A) Any
  • (B) Same
  • (C) Sorted
  • (D) Constant

A

Admin • 833.24K Points
Coach

Q. Choose the correct statement regarding superkeys

  • (A) A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple
  • (B) A superkey is a tuple or a set of multiple tuples that can uniquely identify an attribute
  • (C) Every superkey is a candidate key
  • (D) A superkey is an attribute or a set of attributes that distinguish the relation from other 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.