JOIN ADRE 2.0 Telegram Group

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]
Advertisement
Article and Schedule Quiz Start Test!

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

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]

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!

Chapters

Advertisement
Assam Direct Recruitment Test Series