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: Review relational algebra set operations.
- Union: Merges tuples from two relations, eliminating duplicates.
- Intersect: Selects tuples present in both relations.
- Set Difference: Retrieves tuples from one relation that are not in the other.
- Cartesian Product: Generates all possible combinations of tuples from two relations.

Step 2: Identify the appropriate operation.
Given the requirement for "common tuples," the operation to be applied is Intersect.
Final Answer: \[\boxed{\text{Intersect}}\]