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

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

A

Admin • 833.24K Points
Coach

Q. The is the one in which the primary key of one relation is used as a normal attribute in another relation.

  • (A) referential relation
  • (B) referencing relation
  • (C) referenced relation
  • (D) referred relation

A

Admin • 833.24K Points
Coach

Q. A integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

  • (A) referential
  • (B) referencing
  • (C) specific
  • (D) primary

A

Admin • 833.24K Points
Coach

Q. The operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

  • (A) select
  • (B) join
  • (C) union
  • (D) intersection

A

Admin • 833.24K Points
Coach

Q. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

  • (A) join
  • (B) cartesian product
  • (C) intersection
  • (D) set difference

A

Admin • 833.24K Points
Coach

Q. The operation performs a set union of two “similarly structured” tables

  • (A) union
  • (B) join
  • (C) product
  • (D) intersect

A

Admin • 833.24K Points
Coach

Q. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

  • (A) join
  • (B) projection
  • (C) select
  • (D) union

A

Admin • 833.24K Points
Coach

Q. The connective tests for set membership, where the set is a collection of values produced by a select clause. The connective tests for the absence of set membership.

  • (A) or, in
  • (B) not in, in
  • (C) in, not in
  • (D) in, or

A

Admin • 833.24K Points
Coach

Q. The phrase “greater than at least one” is represented in SQL by

  • (A) < all
  • (B) < some
  • (C) > all
  • (D) > some

A

Admin • 833.24K Points
Coach

Q. SQL applies predicates in the clause after groups have been formed, so aggregate functions may be used.

  • (A) group by
  • (B) with
  • (C) where
  • (D) having

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.