Relational Algebra

Which relational algebra operation is used to select specific rows from a relation based on a condition?

• A. PROJECT (π)
  

• B. SELECT (σ)
  

• C. UNION

• D. CARTESIAN PRODUCT

What does the PROJECT (π) operation do in relational algebra?

• A. Select rows based on a condition

• B. Combine tuples from two relations

• C. Select specific attributes to form a new relation

• D. Find the intersection of two relations

What is the result of the PROJECT operation in the following example?
πName, Marks, Result(STUDENT)

• A. A relation with all rows and all columns

• B. A relation with only the columns Name, Marks, and Result

• C. A relation with selected rows matching a condition

• D. A Cartesian product of Name, Marks, and Result

Which of the following operations is used to find common tuples between two relations?

• A. INTERSECTION

• B. UNION

• C. SET DIFFERENCE

• D. CARTESIAN PRODUCT

What is the result of the SELECT operation in the following example?
σBatch="Science"(STUDENT)

• A. A relation with all rows and all columns

• B. A relation with only students in the "Science" batch

• C. A relation with specific attributes like Name and Batch

• D. A Cartesian product of Science and STUDENT