Question

__________ operation is used to get the common tuples from two relations.

• A. Union
• B. Intersect
• C. Set Difference
• D. Cartesian product

Hint:

In relational algebra: Union = combine, Intersect = common, Difference = exclusion, Cartesian Product = pairing.

Answer 1

The Correct Option is B

Step 1: Recall set operations in relational algebra.
- Union: Combines all tuples from two relations (duplicates removed).
- Intersect: Returns only the common tuples between two relations.
- Set Difference: Returns tuples in one relation but not in the other.
- Cartesian Product: Returns all possible pairings of tuples from two relations.

Step 2: Apply definition.
Since the question asks for “common tuples,” the correct operation is Intersect.
Final Answer: \[ \boxed{\text{Intersect}} \]