UTpaper

Free mock tests & test series

Question 41

______ operation preserves those tuples that would be lost in ______.

  1. ANatural join, outer join
  2. BOuter join, natural join
  3. CLeft outer join, right outer join
  4. DLeft outer join, natural join
Show answerHide answer

Correct answer: (B) Outer join, natural join

Explanation

An outer join keeps the unmatched tuples, padded with NULLs, that a natural join would drop.

From DSSSB TGT Computer Science Practice Set 5

This is question 41 of DSSSB TGT Computer Science Practice Set 5. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.