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

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 relation changes can be got back using command

  • (A) flashback
  • (B) purge
  • (C) delete
  • (D) getback

A

Admin • 833.24K Points
Coach

Q. Let us consider phone_number ,which can take single or several values . Treating phone_numberas an permits instructors to have several phone numbers (including zero) associated with them.

  • (A) entity
  • (B) attribute
  • (C) relation
  • (D) value

A

Admin • 833.24K Points
Coach

Q. The total participation by entities is represented in E-R diagram as

  • (A) dashed line
  • (B) double line
  • (C) double rectangle
  • (D) circle

A

Admin • 833.24K Points
Coach

Q. Given the basic ER and relational models, which of the following is INCORRECT?

  • (A) an attribute of an entity can have more than one value
  • (B) an attribute of an entity can be composite
  • (C) in a row of a relational table, an attribute can have more than one value
  • (D) in a row of a relational table, an attribute can have exactly one value or a null value

A

Admin • 833.24K Points
Coach

Q. Which of the following indicates the maximum number of entities that can be involved in a relationship?

  • (A) minimum cardinality
  • (B) maximum cardinality
  • (C) erd
  • (D) greater entity count

A

Admin • 833.24K Points
Coach

Q. Which function is used to identify the title with Least scope?

  • (A) min(credits)
  • (B) max(credits)
  • (C) min(title)
  • (D) min(salary)

A

Admin • 833.24K Points
Coach

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

  • (A) atomic
  • (B) subatomic
  • (C) substructure
  • (D) subset

A

Admin • 833.24K Points
Coach

Q. Identify the composite attributes

  • (A) salary
  • (B) credits
  • (C) section_id
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which one is based on multi-valued dependency:

  • (A) first
  • (B) second
  • (C) third
  • (D) fourth

A

Admin • 833.24K Points
Coach

Q. If a relation is in BCNF, then it is also in

  • (A) 1 nf
  • (B) 2 nf
  • (C) 3 nf
  • (D) all of the mentioned

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.