Home »
MCQs »
DBMS MCQs
DBMS Relational Algebra Multiple-Choice Questions (MCQs)
DBMS Relational Algebra MCQs: This section contains DBMS Relational Algebra Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on February 21, 2022
1. The relational algebra query language is ___.
- Analytical
- Procedural
- Symmetrical
- Instrumental
Answer: B) Procedural
Explanation:
The relational algebra query language is procedural.
Discuss this Question
2. In Relational Algebra, queries are performed using ___.
- Entities
- Relationships
- Operators
- Objects
Answer: C) Operators
Explanation:
In Relational Algebra, queries are performed using operators.
Discuss this Question
3. How many types of relational operations are there?
- 6
- 7
- 8
- 9
Answer: B) 7
Explanation:
There are 7 relational operations.
- Select Operation
- Project Operation
- Union Operation
- Set Intersection
- Set Difference
- Cartesian Product
- Rename Operation
Discuss this Question
4. Which of the following is NOT a type of relational operation?
- Select Operation
- Set Difference
- Set Update
- Cartesian Product
Answer: C) Set Update
Explanation:
Set Update is NOT a type of relational operation.
Discuss this Question
5. Which of the following is a type of relational operation?
- Project Operation
- Union Operation
- Set Difference
- All of the above
Answer: D) All of the above
Explanation:
The types of relational operations are -
- Select Operation
- Project Operation
- Union Operation
- Set Intersection
- Set Difference
- Cartesian Product
- Rename Operation
Discuss this Question
6. Using the select operation, you can select ___ that satisfy certain criteria.
- Tuples
- Attributes
- Operators
- None
Answer: A) Tuples
Explanation:
Using the select operation, you can select tuples that satisfy certain criteria.
Discuss this Question
7. Select operation is denoted by -
- σ
- R
- P
- S
Answer: A) σ
Explanation:
Select operation is denoted by σ.
Discuss this Question
8. Propositional logic is conducted using p as a formula, using connectors like -
- AND
- OR
- NOT
- All of the above
Answer: D) All of the above
Explanation:
Propositional logic is conducted using p as a formula, using connectors like: AND, OR and NOT.
Discuss this Question
9. A list of the attributes we wish to appear in the result is displayed in ___ operation.
- Select
- Project
- Union
- Rename
Answer: B) Project
Explanation:
A list of the attributes we wish to appear in the result is displayed in Project operation.
Discuss this Question
10. What is Project Operation denoted by –
- P
- R
- O
- ∏
Answer: D) ∏
Explanation:
Project Operation is denoted by ∏.
Discuss this Question
11. If there are 2 types of tuples, A & B, the ___ operation contains all the tuples that are either in A or B or both in A & B.
- Project
- Select
- Union
- Rename
Answer: C) Union
Explanation:
If there are 2 types of tuples, A & B, the union operation contains all the tuples that are either in A or B or both in A & B.
Discuss this Question
12. Union operation eliminates the ___ tuples.
- Simple
- Single
- Duplicate
- NULL
Answer: C) Duplicate
Explanation:
Union operation eliminates the Duplicate tuples.
Discuss this Question
13. Union operation is denoted by -
- U
- ^
- *
- !
Answer: A) U
Explanation:
Union operation is denoted by U.
Discuss this Question
14. The following conditions must be met by a union operation.
- There must be a common attribute between A and B.
- A duplicate tuple is automatically discarded.
- Both A. and B.
- None of the above
Answer: C) Both A. and B.
Explanation:
The following conditions must be met by a union operation:
- There must be a common attribute between A and B.
- A duplicate tuple is automatically discarded.
Discuss this Question
15. If all the tuples are there in the given two tuples, what operation is it called?
- Union
- Select
- Rename
- Set Intersection
Answer: D) Set Intersection
Explanation:
If all the tuples are there in the given two tuples, this operation is called Set Intersection.
Discuss this Question
16. What does Set Intersection Operation denote as?
- U
- ∩
- ∏
- I
Answer: B) ∩
Explanation:
Set Intersection operation is denoted by ∩.
Discuss this Question
17. What does Set Difference Operation denote as?
- +
- -
- U
- ∩
Answer: B) -
Explanation:
Set Difference Operation is denoted as (-).
Discuss this Question
18. In ___ products, the rows in one table are combined with the rows in another table.
- Cross
- Cartesian
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In Cartesian or Cross products, the rows in one table are combined with the rows in another table.
Discuss this Question
19. Renaming the output relation is done via the ___ operation.
- Update
- Alter
- Rename
- Reverse
Answer: C) Rename
Explanation:
Renaming the output relation is done via the rename operation.
Discuss this Question