This set of Advanced Database Management System focuses on Relational Algebra MCQs (Multiple Choice Questions and Answers).

PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE

• Structured
• Procedural
• Logical
• Relational

#### 2. Which of the following are the fundamental operations in the Relational Algebra?

• Select and Project
• Project and Cartesian product
• Union and set Difference
• All of the Above

#### 3. The select, project and rename operations are called____

• Binary operations
• Ternary Operations
• Unary operations
• None of the above.

#### 4. Which of the following is the Binary Operations?

• Set difference, Union, Project
• Rename, union, Set difference
• Cartesian product, Set difference and project
• Cartesian product, union, set difference

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

• Greek letter rho (ρ)
• Greek letter Pi (π)
• Greek letter sigma (σ)
• Greek letter sigma (ρ)

#### 6. Suppose we want to list all loan numbers and the amount of the loans, but do not care about the branch name. Which of the following operation allows us to produce this relation?

• Set difference
• Union
• Cartesian product
• Project

#### 7. The Project operation selects tuples with some attributes that we wish to include but some attribute we do not want to include in the final relation. We use the lowercase______ to denote Project operation.

• Greek letter rho (ρ)
• Greek letter Pi (π)
• Greek letter sigma (σ)
• Greek letter sigma (ρ)

• U
• ρ
• σ
• π

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

• Set difference
• Union
• Cartesian product
• Projection

#### 10. 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

#### 11. Which of the following operation, denoted by cross (×), allows to combine the information from any two relation.

• Set difference
• Union
• Cartesian product
• Set intersection

#### 12. Suppose we wish to find all customers who have both a loan and an account. Which of the following operation allows us to produce this relation?

• Set difference
• Union
• Cartesian product
• Set intersection or set difference

#### 13. Which of the following operation that allows us to combine certain selections and a Cartesian product into one operation?

• Set-intersection operation
• Natural-Join operation
• Division operation
• Assignment operation

• U
• ρ
• σ

• Division
• Assignment
• Subtraction

• =
• =+
• ==

#### 17. Which of the following take a collection of values and return a single value as a result?

• Join Operation
• Generalized Projection
• Aggregate Function
• All of the above

#### 18. Which of the following operation behave just like join operations except on tuples that do not occur in the join results?

• Outer join
• Generalized Projection
• Projection
• Union, intersection, difference

• Only 1
• Only 2
• 1 and 2
• only 4

• Only 1
• Only 2
• 1 and 2
• only 4

• Only 1
• Only 2
• 1 and 2
• only 3

Share with :