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

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

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

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

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

__________ is a specific domain in the relation which has entries of all tuples.