Open In App

GATE | GATE-CS-2001 | Question 25

Like Article
Like
Save
Share
Report

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


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads