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

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. A table can be logically connected to another table by defining a

  • (A) Super key
  • (B) Candidate key
  • (C) Primary key
  • (D) Unique key

A

Admin • 833.24K Points
Coach

Q. If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

  • (A) Consistent state
  • (B) Parallel state
  • (C) Durable state
  • (D) Inconsistent state

A

Admin • 833.24K Points
Coach

Q. Ensuring isolation property is the responsibility of the

  • (A) Recovery-management component of the DBMS
  • (B) Concurrency-control component of the DBMS
  • (C) Transaction-management component of the DBMS
  • (D) Buffer management component in DBMS

A

Admin • 833.24K Points
Coach

Q. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

  • (A) Relational
  • (B) Structural
  • (C) Procedural
  • (D) Fundamental

A

Admin • 833.24K Points
Coach

Q. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigmA:)

  • (A) Predicates, relation
  • (B) Relation, Predicates
  • (C) Operation, Predicates
  • (D) Relation, Operation

A

Admin • 833.24K Points
Coach

Q. The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

  • (A) Union
  • (B) Set-difference
  • (C) Difference
  • (D) Intersection

A

Admin • 833.24K Points
Coach

Q. In precedence of set operators, the expression is evaluated from

  • (A) Left to left
  • (B) Left to right
  • (C) Right to left
  • (D) From user specification

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. 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

A

Admin • 833.24K Points
Coach

Q. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________

  • (A) Referential relation
  • (B) Referencing relation
  • (C) Referenced relation
  • (D) Referred relation

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.