Question 4
Marks : +2 | -2
Pass Ratio : 100%
What is the difference between a join and an outer join operation?
Explanation: The outer join operation preserves a few tuples that are otherwise lost in the join operation. The outer join operation preserves the tuples to the right of the operation.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
What is the function of a left outer join?
Explanation: The left outer join operation preserves the tuples named before the operation.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
What is the function of inner join?
Explanation: The join operations that do not retain mismatched tuples are called as inner join operations. The inner join operation does not preserve any tuples on either side of the relation.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
What is the function of a full outer join?
Explanation: The full outer join operation preserves the tuples named on both the sides of the operation. Unlike the inner join, outer joins preserve tuples from either or both sides of the operation.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?
Explanation: If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, the remaining values are given a null value.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
What is the function of a right outer join?
Explanation: The right outer join operation preserves the tuples named after the operation.