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 σ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]
Advertisement

Chapters

current affairs 2022 pdf plan

Current Affairs MCQs

Current Affairs Quiz March 2022
Current Affairs Quiz February 2022
Current Affairs Quiz January 2022
Current Affairs Quiz December 2021
Current Affairs Quiz November 2021
Current Affairs Quiz October 2021
Current Affairs Quiz September 2021
Current Affairs Quiz August 2021
Current Affairs Quiz July 2021
Current Affairs Quiz June 2021
Current Affairs Quiz May 2021
Current Affairs Quiz April 2021

State-wise Current Affairs

Andhra Pradesh Current Affairs
Arunachal Pradesh Current Affairs
Assam Current Affairs
Bihar Current Affairs
Chhattisgarh Current Affairs
Delhi Current Affairs
Goa Current Affairs
Gujarat Current Affairs
Haryana Current Affairs
Himachal Pradesh Current Affairs
Jammu & Kashmir Current Affairs
Jharkhand Current Affairs
Karnataka Current Affairs
Kerala Current Affairs
Madhya Pradesh Current Affairs
Maharashtra Current Affairs
Manipur Current Affairs
Meghalaya Current Affairs
Mizoram Current Affairs
Nagaland Current Affairs
Odisha Current Affairs
Puducherry Current Affairs
Punjab Current Affairs
Rajasthan Current Affairs
Sikkim Current Affairs
Tamil Nadu Current Affairs
Telangana Current Affairs
Tripura Current Affairs
Uttarakhand Current Affairs
Uttar Pradesh Current Affairs
West Bengal Current Affairs

Month-wise Current Affairs 2022

March 2022
February 2022
January 2022
December 2021
November 2021
October 2021
September 2021
August 2021

Category-wise Current Affairs

Agriculture Current Affairs
Art & Culture Current Affairs
Awards & Prizes Current Affairs
Bank Current Affairs
Bill & Acts Current Affairs
Committees and Commissions Current Affairs
Memorandum of Understanding Current Affairs
Days & Events Current Affairs
Economic Survey 2020-21 Currrent Affairs
Environment Current Affairs
Festivals Current Affairs
Finance Current Affairs
Health Current Affairs
History Current Affairs
Indian Polity Current Affairs
International Relationship Current Affairs
NITI Aayog Current Affairs
Science & Technology Current Affairs
Sports Current Affairs
Union Budget 2021 Current Affairs

Jobs by Qualification

8th Pass Jobs
10th Pass Jobs
12th Pass Jobs
BCA Pass Jobs
B.Com Pass Jobs
B.Ed Pass Jobs
B.Sc Pass Jobs
B.tech Pass Jobs
LLB Pass Jobs
M.Com Pass Jobs
M.Sc Pass Jobs
M.Tech Jobs
MCA Pass Jobs
MA Pass Jobs
MBBS Pass Jobs
MBA Pass Jobs

Free Mock Test

Current Affairs Mock Test
IBPS Exam Mock Test
Indian History Mock Test
Political Science Mock Test
RBI Mock Test
RBI Assistant Mock Test
RBI Grade B General Awareness Mock Test
RRB NTPC General Awareness Mock Test
SBI Mock Test
SBI PO Mock Test
SSC Mock Test
SSC General Awareness Mock Test