Quiz: Outer Joins

Test: Quiz: Outer Joins

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1


1. The ID column in the CLIENT table that corresponds to the CLIENT_ID column of the ORDER table contains null values for rows that need to be displayed. Which type of join should you use to display the data?     Mark for Review

(1) Points


Self join

Outer join (*)


Correct Correct


2. To perform a valid outer join between DEPARMENTS and EMPLOYEES to list departments without employees select the correct WHERE clause for the following select statement:

SELECT d.department_name, e.last_name

FROM employees e, departments d


Mark for Review

(1) Points

e.department_id(+) = d.department_id (*)

e.department_id(+) = d.department_id(+)

e.department_id = d.department_id(+)

e.department_id = d.department_id



3. The following is a valid outer join statement:

SELECT c.country_name, d.department_name

FROM countries c, departments d

WHERE c.country_id (+) = d.country_id (+)

True or False?

Mark for Review

(1) Points


False (*)



4. Which symbol is used to perform an outer join? Mark for Review

(1) Points



(+) (*)


Solution for Test: Quiz: Introduction to The Oracle Academy
Solution for Test: Quiz: Data vs Information