UTpaper

Free mock tests & test series

Question 46

In relational databases, the natural join of two tables is :

  1. ACartesian Product always.
  2. BCombination of Union and filtered Cartesian Product.
  3. CCombination of Selection and filtered Cartesian Product.
  4. DCombination of Projection and filtered Cartesian Product.
Show answerHide answer

Correct answer: (D) Combination of Projection and filtered Cartesian Product.

Explanation

A natural join takes the Cartesian product, keeps the rows where common attributes are equal (selection), then projects away the duplicate columns. So it is a projection of a filtered Cartesian product.

From DSSSB TGT Computer Science Practice Set 1

This is question 46 of DSSSB TGT Computer Science Practice Set 1. 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.