Open In App

UGC-NET | UGC NET CS 2016 July – III | Question 9

Like Article
Like
Save Article
Save
Share
Report issue
Report

Consider the relations R(A, B) and S(B, C) and the following four relational algebra queries over R and S:
I. ΠA, B (R ⨝ S)
II. R ⨝ ΠB(S)
III. R ∩ (ΠA(R) × ΠB(S))
IV. ΠA, R.B (R × S) where R⋅B refers to the column B in table R.
One can determine that:
(A) I, III and IV are the same query.
(B) II, III and IV are the same query.
(C) I, II and IV are the same query.
(D) I, II and III are the same query.


Answer: (D)

Explanation:

Quiz of this Question
Please comment below if you find anything wrong in the above post


Last Updated : 23 Apr, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads