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

In relational algebra, what does the "projection" operation do?a.It selects specific rows from a table.b.It combines two tables into one.c.It selects specific columns from a table.d.It performs a cross join between two tables.

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

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

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

What is relational algebra?Select one:a.The mathematical basis for SQLb.A language used to store data in a databasec.The translation of a query by an SQL compilerd.An informal way to describe how a database works