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
Last Updated :
25 Jun, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...