CompTIA
DY0-001 · Question #70
A data analyst wants to generate the most data using tables from a database. Which of the following is the best way to accomplish this objective?
The correct answer is D. FULL OUTER JOIN. A full outer join returns every row from both tables, matched where possible and unmatched rows filled with NULLs, yielding at least as many (and typically more) rows than any other join type.
Data Processing Technologies
Question
A data analyst wants to generate the most data using tables from a database. Which of the following is the best way to accomplish this objective?
Options
- AINNER JOIN
- BLEFT OUTER JOIN
- CRIGHT OUTER JOIN
- DFULL OUTER JOIN
How the community answered
(54 responses)- B2% (1)
- C4% (2)
- D94% (51)
Explanation
A full outer join returns every row from both tables, matched where possible and unmatched rows filled with NULLs, yielding at least as many (and typically more) rows than any other join type.
Topics
#SQL joins#FULL OUTER JOIN#data retrieval#database queries
Community Discussion
No community discussion yet for this question.