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.

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]

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.