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

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 term is used to refer to a row.

  • (A) attribute
  • (B) tuple
  • (C) field
  • (D) instance

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. 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. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

  • (A) candidate key
  • (B) sub key
  • (C) super key
  • (D) foreign key

A

Admin • 833.24K Points
Coach

Q. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

  • (A) name
  • (B) id
  • (C) city
  • (D) city, id

A

Admin • 833.24K Points
Coach

Q. The subset of a super key is a candidate key under what condition?

  • (A) no proper subset is a super key
  • (B) all subsets are super keys
  • (C) subset is a super key
  • (D) each subset is a super key

A

Admin • 833.24K Points
Coach

Q. A is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

  • (A) rows
  • (B) key
  • (C) attribute
  • (D) fields

A

Admin • 833.24K Points
Coach

Q. Which one of the following attribute can be taken as a primary key?

  • (A) name
  • (B) street
  • (C) id
  • (D) department

A

Admin • 833.24K Points
Coach

Q. Which one of the following cannot be taken as a primary key?

  • (A) id
  • (B) register number
  • (C) dept_id
  • (D) street

A

Admin • 833.24K Points
Coach

Q. An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.

  • (A) candidate
  • (B) primary
  • (C) super
  • (D) sub

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.