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

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. Which of the following is a fundamental operation in relational algebra?

  • (A) set intersection
  • (B) natural join
  • (C) assignment
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to denote the selection operation in relational algebra?

  • (A) pi (greek)
  • (B) sigma (greek)
  • (C) lambda (greek)
  • (D) omega (greek)

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. Which is a unary operation:

  • (A) selection operation
  • (B) primitive operation
  • (C) projection operation
  • (D) generalized selection

A

Admin • 833.24K Points
Coach

Q. Which is a join condition contains an equality operator:

  • (A) equijoins
  • (B) cartesian
  • (C) natural
  • (D) left

A

Admin • 833.24K Points
Coach

Q. Which of the following is not outer join?

  • (A) left outer join
  • (B) right outer join
  • (C) full outer join
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. The assignment operator is denoted by

  • (A) ->
  • (B) <-
  • (C) =
  • (D) ==

A

Admin • 833.24K Points
Coach

Q. Which of the following symbol is used in the place of except?

  • (A) ^
  • (B) v
  • (C) ¬
  • (D) ~

A

Admin • 833.24K Points
Coach

Q. Which of the following is the comparison operator in tuple relational calculus

  • (A) ⇒
  • (B) =
  • (C) ε
  • (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.