The operation that takes two relations and combines them based on common attributes is the _________ operation.
A) join
B) project
C) union
D) intersection

Question

Quizplus · Accepted Answer

The join operation is used to combine two relations based on common attributes. This operation matches tuples from each relation where the values of the common attributes match, and creates a new relation with the combined attributes from both original relations. Project, union, and intersection operations do not merge two relations based on common attributes.

The Operation That Takes Two Relations and Combines Them Based