FULL OUTER JOIN & UNION Emulation — Concept Check
Questions on FULL OUTER JOIN & UNION Emulation. FULL OUTER JOIN returns all rows from both tables with NULLs for unmatched sides; it can be emulated in MySQL using UNION of LEFT and RIGHT JOINs.
Questions in this quiz
8 questions on FULL OUTER JOIN & UNION Emulation — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.In MySQL, you need to emulate a FULL OUTER JOIN. Which combination of operations would achieve this?
- ARIGHT JOIN and INNER JOIN with UNION
- BLEFT JOIN and INNER JOIN with UNION
- CINNER JOIN and LEFT JOIN with UNION
- DLEFT JOIN and RIGHT JOIN with UNION
2.A developer wants to reconcile differences between two product tables in MySQL. Which query pattern should they use?
- ARIGHT JOIN only
- BLEFT JOIN and RIGHT JOIN with UNION
- CFULL OUTER JOIN directly
- DINNER JOIN only
3.A MySQL query uses UNION instead of UNION ALL. What impact does this have?
- APerforms faster than UNION ALL
- BCauses syntax errors
- CKeeps duplicate rows
- DRemoves duplicate rows
4.In a reconciliation query, you notice NULL values in some columns. What does this indicate?
- AAll rows matched perfectly
- BThere are syntax errors in the query
- CRows exist in one table but not the other
- DBoth tables are empty
5.A developer claims that using UNION ALL is always better for performance. What is a potential flaw in this reasoning?
- AUNION ALL causes syntax errors
- BUNION ALL is not supported in MySQL
- CUNION ALL is slower than UNION
- DUNION ALL retains duplicates, which may not be desired
6.What does the COALESCE function do in a FULL OUTER JOIN query?
- ASorts the result set
- BCombines two tables into one
- CReturns the first non-NULL value
- DRemoves NULL values
7.In MySQL, why might you choose UNION ALL over UNION when emulating a FULL OUTER JOIN?
- ATo ensure duplicates are removed
- BTo prevent syntax errors
- CTo improve performance by avoiding deduplication
- DBecause UNION ALL is the only option
8.Which statement about FULL OUTER JOIN is true?
- AIt only returns rows with matches in both tables
- BIt always performs better than LEFT JOIN
- CIt is natively supported in MySQL
- DIt returns all rows from both tables, with NULLs for unmatched rows