Relational Algebra Quiz

What is the primary purpose of relational algebra?

• Storing data in tables

• Defining how to retrieve and manipulate data in a database

• Encrypting data for security

• Creating programming languages

Which of the following is a procedural query language?

• Relational Algebra

• Relational Calculus

• SQL

• NoSQL

Which relational algebra operation selects a subset of rows based on a condition?

• Projection (π)

• Selection (σ)

• Union (∪)

• Cartesian Product (×)

The Projection (π) operator is used to...

• Remove duplicate rows from a relation

• Select specific columns from a relation

• Combine two relations

• Perform arithmetic operations on tuples

Which relational algebra operation removes duplicate tuples from the result?

• Selection

• Projection

• Union

• Cartesian Product

What does the Cartesian Product (×) operation do?

• Joins two relations on a common attribute

• Combines all rows from one relation with all rows from another

• Finds common elements between two relations

• Deletes tuples from a relation

Which of the following operations is not fundamental in relational algebra?

• Selection

• Projection

• Join

• Intersection

The Set-Difference (−) operator returns tuples that...

• Are common in both relations

• Are present in the first relation but not in the second

• Are present in the second relation but not in the first

• Are the union of both relations

Two relations are union-compatible if...

• They have the same number of tuples

• They have the same attributes and data types

• They have at least one common attribute

• They have no common attributes

What is the result of the Intersection (∩) operation?

• A set containing all unique tuples from both relations

• A set containing only tuples present in both relations

• A set containing tuples from the first relation but not the second

• A set containing tuples from the second relation but not the first