Skip to content
Related Articles

Related Articles

UGC-NET | UGC NET CS 2014 Dec – II | Question 17
  • Last Updated : 25 Jun, 2018
GeeksforGeeks - Summer Carnival Banner

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

    Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

    My Personal Notes arrow_drop_up
  • Recommended Articles
    Page :