GkSeries.com

MCQs on Relational Algebra and Calculus - DBMS Objective Questions with Answers

Download PDF

DBMS multiple choice questions and answers page contain 5 questions from chapter Relational algebra and calculus. Each objective question has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(16) The JOIN operator can be specified as :
[A] R x S
[B] σ(condition)(R x S)
[C] Both [A] and [B]
[D] None of these

Comment

Answer: Option [C]
(17) The expression (R ∪ S)-((R-S) ∪ (S-R)) is equivalent to
[A] R/S
[B] R ∩ S
[C] σ(condition)(R x S)
[D] ∏(R x S)

Comment

Answer: Option [A]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(18) If P and Q are predicates and P is the relational algebra expression, then which of the following equivalences are valid ?
[A] σP(σQ(e))=σQ(σP(e))
[B] σP(σQ(e))=σQ(e)
[C] nσQ(σP(e))=σQ(σP(e))
[D] none of these

Comment

Answer: Option [D]
(19) Which one is not a version of JOIN ?
[A] Equi join
[B] Outer join
[C] Natural join
[D] All are versions of JOIN

Comment

Answer: Option [D]
(20) Relational calculus is :
I. equivalent to relational algebra in its capabilities.
II. it is stronger than relational algebra.
III. it is weaker than relational algebra.
IV. it is based on predicate calculus of formal logic.

Now answer which one is correct option ?

[A] (I) and (IV) are true
[B] (II) and (IV) are true
[C] only (III) is true
[D] (III) and (IV) are true

Comment

Answer: Option [D]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test