Join our Telegram Channel

1000 POLITICAL SCIENCE MCQS | EBook
Get 22 nos. GK EBooks | Combo Pack
Current Affairs Monthly Magazine -Subscribe Now!
1000 BIOLOGY MCQS AND ANSWERS | EBook
1000 ECONOMICS MCQS FOR EXAMS | EBook
Mughal Empire MCQs | EBook
ECONOMIC GEOGRAPHY MCQs | EBook
350 MCQs ON INDIAN CONSTITUTION | EBook
GENERAL AWARENESS COMBO (6 EBOOKS)

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

Questions
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

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)

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

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

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

Answer: Option [D]
Advertisement

Chapters

Month-wise Current Affairs 2022

Category-wise Current Affairs

Jobs by Qualification

Free Mock Test