Exit 1Z0-071 Oracle Database SQL
Question 1 of 5
0% complete
Q1 Single choice

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.

Which SQL statement must you use?

  • A

    SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN
    course_details c ON (d.department_id=c. department_id);

  • B

    SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details
    c ON (d.department_id=c. department_id);

  • C

    SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details
    d ON (c.department_id=d. department_id);

  • D

    SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN

    course_details c ON (c.department_id=d. department_id);

Previous Next