Open In App

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

Like Article
Like
Save
Share
Report

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
    Previous
    Next
    Share your thoughts in the comments
    Similar Reads