The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.a.Intersectionb.Set differencec.Cartesian productd.Join

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

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

set_X = {1, 2, 3, 4, 5}set_Y = {4, 5, 6, 7, 8}What operation will result in a set containing elements that are in either set_X or set_Y but not in both?  1 pointset_X.difference(set_Y)set_X.symmetric_difference(set_Y)set_X.intersection(set_Y)set_X.union(set_Y)

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