Relational Algebra Quiz

The relational Algebra is a ____________ Query language.

• Procedural

• Relational

• Logical

• Structured

Which of the following are the fundamental operations in the Relational Algebra?

• All of the Above

• Union and set Difference

• Project and Cartesian product

• Select and Project

The select, project and rename operations are called____

• None of the above

• Unary operations

• Ternary Operations

• Binary operations

Which of the following is the Binary Operations?

• Rename, union, Set difference

• Cartesian product, union, set difference

• Set difference, Union, Project

• Cartesian product, Set difference and project

The select operation selects tuples that satisfy a given predicate. We use the lowercase______ to denote selection.

• Greek letter sigma (σ)

• Greek letter Pi (π)

• Greek letter rho (ρ)

• Greek letter tau (τ)

Which of the following operation allows us to produce a relation listing all loan numbers and the amount of the loans?

• Cartesian product

• Union

• Set difference

• Project

The Binary operation Union, denoted, as in the set theory by _____

• ρ

• π

• U

• σ

If we want to include attributes from two different relations, which of the following operations is needed?

• Cartesian product

• Set difference

• Union

• Projection

Which of the following operation allows us to find the tuples that are in one relation but are not in another relation?

• Set difference

• Union

• Cartesian product

• Set intersection

Which of the following operation, denoted by cross (×), allows to combine the information from any two relations?

• Set intersection

• Set difference

• Cartesian product

• Union