Question

The join operations that do not retain mismatched tuples are called as _________ operations

(a) outer join

(b) natural join

(c) full outer join

(d) inner join

This question was posed to me during an online exam.

This is a very interesting question from Join Expressions topic in division Intermediate and Advanced Sql of RDBMS

Answer 1

Right option is (d) inner join

Easy explanation: The join operations that do not retain mismatched tuples are called as inner join operations. The inner join operations do not preserve any tuples that are otherwise preserved in the outer join operation.