JOIN ADRE 2.0 Telegram Group

Relational Algebra and Calculus MCQs | Database Management System Multiple Choice Questions and Answers

Questions
1 If E1 and E2 are relational algebra expressions, then which of the following is NOT a relational algebra expression ?
A E1 ∪ E2
B E1 / E2
C E1 - E2
D E1 x E2

Answer: Option [B]
2 The operation of a relation X, produces Y, such that Y contains only selected attributes of X. Such an operation is :
A Projection
B Intersection
C Union
D Difference

Answer: Option [A]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

3 If T1 and T2 are two relations, then which of the following is not a valid relational algebra expression ?
A T1 - T2
B T1 ∪ T2
C T1 ∩ T2
D All are valid expressions

Answer: Option [D]
4 Which of the following is not valid unary operation in the relational algebra ?
A select
B min
C project
D rename

Answer: Option [B]
5 Relational algebra is :
A Data Definition Language
B Meta Language
C Procedural query language
D Non procedural language

Answer: Option [C]

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