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

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]

Random GK Questions

Q. One of the following excretes uric acids as its excretory product:
Q. Section 115 of CPC applies only when :
Q. The main channels of our knowledge about the Indus Valley Civilization are:
Q. Forced Savings refer to
Q. Guru Gopinath was an exponent of
Q. Number of chromosomes present in gorilla is:

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics