The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple. SelectJoinUnionIntersection

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.JoinCartesian productIntersectionSet difference

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.IntersectionSet differenceCartesian productJoin

Which of the join operations do not preserve non matched tuples?

One operation we might want to perform on a relation is to select _______ possessing certain characteristics and to place these selected _______ in a new relation.

What does the intersection operation in relational algebra produce?a.A new relation containing only the tuples that appear in one input relation but not the otherb.A new relation containing only the tuples that appear in both input relationsc.A new relation containing only the common tuples from both input relationsd.A new relation containing all tuples from both input relations, eliminating duplicates