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

Discussion

The natural join is equal to :

  • A.Cartesian Product
  • B.Combination of Union and Cartesian product
  • C.Combination of selection and Cartesian product
  • D.Combination of projection and Cartesian product

Answer: C

Correct answer: Combination of selection and Cartesian product

A natural join is built from the basic operators: form the Cartesian product of the two relations, then select the tuples whose common attributes are equal - and finally project away the duplicated columns. That is why the join is a derived operation rather than a primitive of relational algebra.

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

Post your comment

Please log in or register to post a comment.