Oracle
1Z0-071 · Question #99
Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or…
The correct answer is C. SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN. See the full explanation below for the reasoning.
Question
Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:
You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses. Which SQL statement must you use?
Exhibit
Options
- ASELECT course_id, department_id, FROM department_details d RIGHT OUTER JOIN
- BSELECT c.course_id, d.department_id FROM course_details c RIGHT OUTER
- CSELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN
- DSELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN
How the community answered
(39 responses)- A3% (1)
- B10% (4)
- C85% (33)
- D3% (1)
Community Discussion
No community discussion yet for this question.