This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL Full Join”.
1. Which of the following joins return very large result-sets when compared with other joins?
a) Inner join
b) Right join
c) Left join
d) Full join
View Answer
Explanation: The FULL OUTER JOIN returns all the records when there is a match in either left or right table records. So, it can potentially return very large result-sets when compared with other joins.
2. Which of the following sets represents the result-set of Table1 FULL JOIN Table2?
a) Table1
b) Table1 U Table2
c) Table2
d) Table1 ∩ Table2
View Answer
Explanation: FULL JOIN creates the result-set by combining result of both LEFT JOIN and RIGHT JOIN. The result-set will contain all the rows from both the tables i.e. Table1 U Table2.
3. For the missing matches of any table joined by using FULL JOIN, the result-set contains _______
a) Space
b) Zero
c) Null
d) Blank
View Answer
Explanation: The SQL full join is the result of combination of both left and right outer join. It puts NULL on the place of matches not found.
4. Full join is a type of INNER JOIN.
a) True
b) False
View Answer
Explanation: Full join is a type of outer join that’s why it is also referred as full outer join. Using FULL OUTER JOIN in the place of FULL JOIN doesn’t affect the result-set.
Sanfoundry Global Education & Learning Series – SQL.
To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.