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

Discussion

Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.

  • A.True
  • B.False

Answer: B

Correct answer: False

Eliminating the duplicate column is what distinguishes the natural join from the equi-join. An outer join does something else entirely: it keeps the rows that have no match on the other side, filling their missing columns with nulls. The statement has attached one join’s definition to another’s name.

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

Post your comment

Please log in or register to post a comment.