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


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



Correct Correct


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 (*)



Correct Correct


4. Which symbol is used to perform an outer join? Mark for Review
(1) Points


*


||


(+) (*)


#



Correct Correct

( Vrei sa traduci ceva?Want to translate something? http://translate.google.ro/# )