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]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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]

Chapters

ADRE 3.0 Complete Study Material