Question

What is the function of inner join?

(a) It preserves tuples only in the relation named before the operation

(b) It preserves tuples only in the relation named after the operation

(c) It preserved tuples in the relations named on both the sides of the operation

(d) It does not preserve any tuples on either side of the relation

I got this question in homework.

The question is from Join Expressions in chapter Intermediate and Advanced Sql of RDBMS

Answer 1

The correct choice is (d) It does not preserve any tuples on either side of the relation

The best I can explain: The join operations that do not retain mismatched tuples are called as inner join operations. The inner join operation does not preserve any tuples on either side of the relation.