Which of the following join types will produce only the rows for which two tables' common attribute values match exactly:
A) Equi-join
B) Right outer join
C) Inner join
D) Both equi-join and inner join
E) Left outer join

Question

Quizplus · Accepted Answer

Both equi-join and inner join will produce only the rows where the common attribute values in the two tables match exactly. An equi-join is a specific type of inner join that uses equality for matching.

Which of the Following Join Types Will Produce Only the Rows