GkSeries.com

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

(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]

Please share this page

Chapters

Click Here to Read more questions

Teacher Eligibility Test