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

Discussion

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

  • A.left outer join
  • B.right outer join
  • C.full outer join

  • D.inner join

Answer: D

Correct answer: inner join

An inner join returns only the pairs of rows that match, discarding unmatched rows from both sides. The outer joins exist precisely to keep them: left keeps the unmatched rows of R, right those of S, and full both.

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

Post your comment

Please log in or register to post a comment.