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
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 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 MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

Advertisement