SQL Questions and Answers – SQL Full Join

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

Answer: d
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

Answer: b
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

Answer: c
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.
advertisement
advertisement

4. Full join is a type of INNER JOIN.
a) True
b) False
View Answer

Answer: b
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.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.