Home »
MCQs »
DBMS MCQs
DBMS Join Operations Multiple-Choice Questions (MCQs)
DBMS Join Operations MCQs: This section contains DBMS Join Operations Multiple-Choice Questions (MCQs).
Submitted by Anushree Goswami, on March 28, 2022
1. If and only if a given ___ condition is met, a ___ operation will combine related tuples from separate relations.
- Join
- Return
- Date
- Constraint
Answer: A) Join
Explanation:
If and only if a given join condition is met, a Join operation will combine related tuples from separate relations.
Discuss this Question
2. What is Join Operation denoted by?
- U
- (
- &
- ⋈
Answer: D) ⋈
Explanation:
Join Operation is denoted by ⋈.
Discuss this Question
3. How many types of Join Operation are there?
- 2
- 3
- 4
- 5
Answer: B) 3
Explanation:
There are 3 types of Join Operations.
Discuss this Question
4. Which among the following is a type of Join Operation?
- Natural Join
- Outer Join
- Equi Join
- All of the above
Answer: D) All of the above
Explanation:
Types of Join Operations are -
- Natural Join
- Outer Join
- Equi Join
Discuss this Question
5. How many types of outer joins are there?
- 2
- 3
- 4
- 5
Answer: B) 3
Explanation:
There are three types of Outer Join: LEFT JOIN , RIGHT JOIN , and FULL JOIN.
Discuss this Question
6. Which among the following is NOT an Outer Join Operation?
- Left Outer Join
- Right Outer Join
- Natural Join
- Full Outer Join
Answer: C) Natural Join
Explanation:
Natural Join is a type of Join Operation and not an Outer Join Operation.
Discuss this Question
7. It is the set of all the tuples that have the ____ attribute names in each of A and S.
- Same
- Different
- Lesser
- Greater
Answer: A) Same
Explanation:
It is the set of all the tuples that have the same attribute names in each of A and S.
Discuss this Question
8. What does Natural Join Operation denote as?
- N
- J
- ⋈
- U
Answer: C) ⋈
Explanation:
Natural Join Operation is denoted as ⋈.
Discuss this Question
9. Which of the following operations is an extension of the Join Operation?
- Natural
- Outer
- Inner
- Equi
Answer: B) Outer
Explanation:
The Outer Join Operation is an extension of the Join Operation.
Discuss this Question
10. A ___ piece of information can be handled by the outer join operation.
- Known
- Missing
- Unused
- None
Answer: B) Missing
Explanation:
A missing piece of information can be handled by the outer join operation.
Discuss this Question
11. What is TRUE about Left Outer Join?
- It contains all tuples that have the same common attribute names in A and B.
- Tuples in A do not match tuples in B in the left outer join.
- It is denoted by ⟕.
- All of the above
Answer: D) All of the above
Explanation:
Explanation: In case of Left Outer Join -
- It contains all tuples that have the same common attribute names in A and B.
- Tuples in A do not match tuples in B in the left outer join.
- It is denoted by ⟕.
Discuss this Question
12. What is TRUE about Right Outer Join?
- It contains all tuples that have the same common attribute names in A and B
- Tuples in B do not match tuples in A in the left outer join
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In case of Right Outer Join -
- It contains all tuples that have the same common attribute names in A and B.
- Tuples in B do not match tuples in A in the left outer join.
Discuss this Question
13. What does Right Outer Join denote by?
- ⋈
- ⟕
- ⟖
- All of the above
Answer: C) ⟖
Explanation:
Right outer join is denoted by ⟖.
Discuss this Question
14. An outer join that contains all rows from both tables is like a ___.
- Left Join
- Right Join
- Natural Join
- Both A and B
Answer: D) Both A and B
Explanation:
An outer join that contains all rows from both tables is like a left or right join.
Discuss this Question
15. With a ___, no tuples in A have any matches in B, and there are no tuples in B that have any matches in A.
- Natural Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
Answer: D) Full Outer Join
Explanation:
With a full outer join, no tuples in A have any matches in B, and there are no tuples in B that have any matches in A.
Discuss this Question
16. What does Full Outer Join denote as?
- ⟗
- ⋈
- ⟕
- ⟖
Answer: A) ⟗
Explanation:
Full Outer Join is denoted as ⟗.
Discuss this Question
17. What does Equi Join also known as?
- Inner Join
- Outer Join
- Natural Join
- None
Answer: A) Inner Join
Explanation:
Equi Join is also known as Inner Join.
Discuss this Question
18. According to the ___ condition, Inner Join is derived from matched data.
- Greater than
- Lesser than
- Equality
- Null
Answer: C) Equality
Explanation:
According to the equality condition, Inner Jo is derived from matched data.
Discuss this Question
19. A ___ is used for the equi join.
- Equal Operation
- Comparison Operation
- Equi Operation
- Contrast Operation
Answer: B) Comparison Operation
Explanation:
A comparison operator is used for the equi join.
Discuss this Question
20. What does Comparison Operator denote as?
- =
- ⋈
- {}
- <>
Answer: A) =
Explanation:
Comparison Operator is denoted as =.
Discuss this Question