Skip to content
Related Articles

Related Articles

GATE | GATE-CS-2001 | Question 25

Improve Article
Save Article
  • Last Updated : 28 Jun, 2021
Improve Article
Save Article

Let r and s be two relations over the relation schemes R and S respectively, and let A be an attribute in R. then the relational algebra expression GATECS200Q25B is always equal to

GATECS200Q25
(A) A
(B) B
(C) C
(D) D


Answer: (C)

Explanation: The above expression evaluates A = a for tables r and s

Option A : is only displaying attributes of table r on the select condition

Option B : is only displaying attributes of table r

Option C: evaluates A = a by joining tables r and s  efficiently , thus correct

Therefore, Answer C

 

Quiz of this Question

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!