Which join operation retrieves tuples that have matching values in both relations?

Correct option is B

The Inner Join operation retrieves tuples from two relations that have matching values in the specified attributes. If there is no match, the tuple is excluded from the result.
Example:

Important Key Points:
1. Inner Join is the most commonly used join operation.
2. It excludes unmatched tuples from the result.
Knowledge Booster:
· Cross Join: Produces the Cartesian product of two relations, combining all tuples without conditions.
· Left Outer Join: Includes all tuples from the left relation, along with matched tuples from the right relation. Unmatched tuples in the left relation are padded with NULLs.
· Right Outer Join: Includes all tuples from the right relation, along with matched tuples from the left relation. Unmatched tuples in the right relation are padded with NULLs.
· Full Outer Join: Includes all tuples from both relations, with unmatched tuples padded with NULLs on either side.