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

(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

Comment

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

Comment

Answer: Option [A]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 Start Test
Government Schemes Mock Test Start Test!
(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

Comment

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

Comment

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

Comment

Answer: Option [C]

Take Mock Tests

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!
Economy Mock Test 4 Unlock Test!
Economy Mock Test 5 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters