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
Equijoin
Self join
Outer join (*)
Nonequi-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
WHERE
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
True
False (*)
4. Which symbol is used to perform an outer join? Mark for Review
(1) Points
*
||
(+) (*)
#
