In Which of the Following Situations Would One Have to Use

question 47

Multiple Choice

In which of the following situations would one have to use an outer join in order to obtain the desired results?

• A) A report is desired that lists all customers who placed an order.
• B) A report is desired that lists all customers and the total of their orders.
• C) A report is desired that lists all customers, the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).
• D) There is never a situation that requires only an outer join.

---

Definitions:

Creditors and Debtors

Creditors are entities or individuals to whom money is owed, while debtors are those who owe money to another party.

Unemployed

The state of being without a paid job despite actively seeking work.

Labor Force

The total number of people employed or seeking employment in a country or particular area.

Unemployment Rate

The percentage of people in the labor force who are not currently employed but are seeking work.