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 result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.IntersectionSet differenceCartesian productJoin

What does the projection operation in relational algebra do?a.Produces a new relation containing tuples that appear in both input relationsb.Retrieves specific rows from a relationc.Retrieves specific columns from a relationd.Combines tuples from two relations based on a common attribute

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.a.Fundamentalb.Relationalc.Structurald.Procedural

Which of the following is NOT an operation in relational algebra?

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