Select Page
Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
Filter by Categories
nmims post
Objective Type Set
Online MCQ Assignment
Question Solution
Solved Question
Uncategorized

1. The on condition appears at the _______ of the join expression
a) Beginning
b) End
c) Between
d) The on condition is not related to join expression

Answer: b [Reason:] The on condition appears at the end of the join expression. Because it states the condition that the relations under the join operations get matched based on.

2. What is the difference between a join and an outer join operation?
a) There is no difference
b) Join preserves a few tuples that are otherwise lost in the outer join
c) Outer join preserves a few tuples that are otherwise lost in the join
d) An outer join can be used only on outer queries whereas a join operation can be used in Subqueries

Answer: c [Reason:] 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.

3. The join operations that do not retain mismatched tuples are called as _________ operations
a) outer join
b) natural join
c) full outer join
d) inner join

Answer: d [Reason:] The join operations that do not retain mismatched tuples are called as inner join operations. The inner join operations do not preserve any tuples that are otherwise preserved in the outer join operation.

4. What is the function of a left outer join?
a) It preserves tuples only in the relation named before the operation
b) It preserves tuples only in the relation named after the operation
c) It preserved tuples in the relations named on both the sides of the operation
d) It does not preserve any tuples on either side of the relation

Answer: a [Reason:] The left outer join operation preserves the tuples named before the operation.

5. What is the function of a full outer join?
a) It preserves tuples only in the relation named before the operation
b) It preserves tuples only in the relation named after the operation
c) It preserved tuples in the relations named on both the sides of the operation
d) It does not preserve any tuples on either side of the relation

Answer: c [Reason:] 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.

6. What is the function of a right outer join?
a) It preserves tuples only in the relation named before the operation
b) It preserves tuples only in the relation named after the operation
c) It preserved tuples in the relations named on both the sides of the operation
d) It does not preserve any tuples on either side of the relation

Answer: b [Reason:] The right outer join operation preserves the tuples named after the operation.

7. What is the function of inner join?
a) It preserves tuples only in the relation named before the operation
b) It preserves tuples only in the relation named after the operation
c) It preserved tuples in the relations named on both the sides of the operation
d) It does not preserve any tuples on either side of the relation

Answer: d [Reason:] 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.

8. State true or false: on and where behave differently for outer join
a) True
b) False

Answer: a [Reason:] The on condition is a part of the outer join syntax but the where clause isn’t.

9. Which off the following is not a valid type of join?
a) left outer join
b) outer join
c) join
d) full join

Answer: d [Reason:] There is no such join called as full join. There is a full outer join but a full join does not exist.

10. 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?
a) They are given null values
b) They are given a random value
c) The user is asked to enter data
d) The query is declared invalid by the compiler