Add a clause to the WHERE condition to make the following query return only the department names without employees:

select employee_id "Emp ID", last_name || ', ' ||
  first_name "Name", department_name "Dept"
from employees e,departments d
where e.department_id(+) = d.department_id;

A type of query that has either too few or no join conditions is known as a ___________ query.

Name three kinds of equijoins.

A natural join makes what assumption between the columns of two or more tables to be joined?

The Oracle9i syntax moves the join conditions from the _________ clause to the ________ clause in a SELECT statement.

To avoid a Cartesian product, a query with four tables must have at least how many join conditions between tables?

To return all the rows in one table regardless of whether any rows in another table match on the join condition, you would use what kind of a join?

What is the symbol used to signify an outer join in a pre-Oracle9i query?

A full outer join uses what SQL set operator in a pre-Oracle9i database query?

A primary key in one table would frequently be joined to what in a second table?