The join operation can be defined as
- A. a cartesian product of two relations followed by a selection
- B. a cartesian product of two relations
- C. a union of two relations followed by cartesian product of the two relations
- D. a union of two relations
Answer: A. a cartesian product of two relations followed by a selection
Explanation: Join allows combining related tuples from two relations, conceptually equivalent to cross product followed by selection on the join condition.