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

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

Article Tags :

UGC-NET

Recommended Articles

1. UGC-NET | UGC NET CS 2016 July – III | Question 45

2. UGC-NET | UGC NET CS 2016 July – III | Question 50

3. UGC-NET | UGC NET CS 2016 July – III | Question 52

4. UGC-NET | UGC NET CS 2016 July – III | Question 53

5. UGC-NET | UGC NET CS 2016 July – III | Question 63

6. UGC-NET | UGC NET CS 2016 July – III | Question 64

7. UGC-NET | UGC NET CS 2016 July – III | Question 65

8. UGC-NET | UGC NET CS 2016 July – III | Question 16

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

10. UGC-NET | UGC NET CS 2016 July – III | Question 25

11. UGC-NET | UGC NET CS 2016 July – III | Question 43

12. UGC-NET | UGC NET CS 2016 July – III | Question 44

13. UGC-NET | UGC NET CS 2016 July – III | Question 56

14. UGC-NET | UGC NET CS 2016 July – III | Question 1

15. UGC-NET | UGC NET CS 2016 July – III | Question 2

16. UGC-NET | UGC NET CS 2016 July – III | Question 3

17. UGC-NET | UGC NET CS 2016 July – III | Question 4

18. UGC-NET | UGC NET CS 2016 July – III | Question 5

19. UGC-NET | UGC NET CS 2016 July – III | Question 6

20. UGC-NET | UGC NET CS 2016 July – III | Question 7

21. UGC-NET | UGC NET CS 2016 July – III | Question 8

22. UGC-NET | UGC NET CS 2016 July – III | Question 10

23. UGC-NET | UGC NET CS 2016 July – III | Question 11

24. UGC-NET | UGC NET CS 2016 July – III | Question 12

25. UGC-NET | UGC NET CS 2016 July – III | Question 13