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

My Personal Notes arrow_drop_up

Save