Machine-translated by Google. Questions are authored in English.
Top

Discussion

A table joined with itself is called

  • A.
    Join
  • B.Self Join
  • C.
    Outer Join
  • D.Equi Join

Answer: B

Correct answer: Self Join

A self join joins a table to itself, using two different aliases so that the two copies can be distinguished. It is how a table that refers to its own rows is unravelled - listing each employee beside their manager, where both are rows of the same employee table.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.