UGC-NET | UGC NET CS 2014 Dec – II | Question 17

Which of the following is true ?
I. Implementation of self-join is possible in SQL with table alias.
II. Outer-join operation is basic operation in relational algebra.
III. Natural join and outer join operations are equivalent.
(A) I and II are correct.
(B) II and III are correct.
(C) Only III is correct.
(D) Only I is correct.

Answer: (D)
Explanation:

Implementation of self-join is possible in SQL with table alias.Correct

Outer-join operation is basic operation in relational algebra.Incorrect

Natural join and outer join operations are equivalent.Incorrect

So, option (D) is correct.
Quiz of this Question

Article Tags :

UGC-NET

Recommended Articles

1. UGC-NET | UGC NET CS 2014 Dec - III | Question 1

2. UGC-NET | UGC NET CS 2014 Dec - III | Question 10

3. UGC-NET | UGC NET CS 2014 Dec - III | Question 2

4. UGC-NET | UGC NET CS 2014 Dec - III | Question 3

5. UGC-NET | UGC NET CS 2014 Dec - III | Question 6

6. UGC-NET | UGC NET CS 2014 Dec - III | Question 4

7. UGC-NET | UGC NET CS 2014 Dec - III | Question 5

8. UGC-NET | UGC NET CS 2014 Dec - II | Question 1

9. UGC-NET | UGC NET CS 2014 Dec - II | Question 2

10. UGC-NET | UGC NET CS 2014 Dec - II | Question 3

11. UGC-NET | UGC NET CS 2014 Dec - II | Question 4

12. UGC-NET | UGC NET CS 2014 Dec - II | Question 5

13. UGC-NET | UGC NET CS 2014 Dec - II | Question 6

14. UGC-NET | UGC NET CS 2014 Dec - II | Question 7

15. UGC-NET | UGC NET CS 2014 Dec - II | Question 8

16. UGC-NET | UGC NET CS 2014 Dec - II | Question 9

17. UGC-NET | UGC NET CS 2014 Dec - II | Question 10

18. UGC-NET | UGC NET CS 2014 Dec - II | Question 11

19. UGC-NET | UGC NET CS 2014 Dec - II | Question 12

20. UGC-NET | UGC NET CS 2014 Dec - II | Question 13

21. UGC-NET | UGC NET CS 2014 Dec - II | Question 14

22. UGC-NET | UGC NET CS 2014 Dec - II | Question 15

23. UGC-NET | UGC NET CS 2014 Dec - II | Question 16

24. UGC-NET | UGC NET CS 2014 Dec - II | Question 18

25. UGC-NET | UGC NET CS 2014 Dec - II | Question 19