Free Test Relational Algebra Ope... – Databas...

Q1: Which relational algebra operation retrieves rows that satisfy a given condition?

A. Select B. Project C. Join D. Union

Q2: Which operation retrieves specific columns from a relation?

A. Project B. Select C. Union D. Join

Q3: What does the Union operation do?

A. Combines tuples from two relations with the same schema B. Filters rows based on condition C. Retrieves specific columns D. Combines tuples from any two relations

Q4: Which operation returns tuples common to two relations?

A. Intersection B. Union C. Difference D. Join

Q5: Which operation returns tuples from the first relation not in the second?

A. Difference B. Union C. Intersection D. Join

Q6: Which operation combines tuples from two relations based on a condition?

A. Join B. Union C. Select D. Project

Q7: What is a natural join?

A. Join on all common attributes automatically B. Join on specified attributes only C. Cross product D. Union operation

Q8: Which operation creates a Cartesian product of two relations?

A. Cross product B. Join C. Union D. Select

Q9: Which operation renames the attributes of a relation?

A. Rename B. Project C. Select D. Union

Q10: Which operation is unary?

A. Select B. Union C. Join D. Difference

Q11: Which operation is binary?

A. Union B. Select C. Project D. Rename

Q12: Which operation filters tuples with condition age > 30?

A. Select B. Project C. Join D. Union

Q13: What is the output of Project operation?

A. Relation with fewer columns B. Relation with fewer rows C. Relation with more rows D. Relation with all columns

Q14: Which operation removes duplicates automatically?

A. Union B. Select C. Project D. Join

Q15: Which operation is used to combine information from multiple relations?

A. Join B. Select C. Project D. Difference

Q16: Which operation cannot be performed if the two relations have different attribute names?