In Which of the Following Situations Would One Have to Use

question 91

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 and 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:

Geographical Region

An area defined by natural or artificial features, political boundaries, or cultural characteristics that distinguish it from surrounding areas.

Limited-Function Merchant Wholesaler

A wholesaler that provides a limited range of services, focusing on specific functions like storage or delivery rather than comprehensive support.

Full-Function Merchant Wholesaler

A wholesaler that provides a range of services including stocking inventory, operating warehouses, and offering credit to retailers.

Logistics

Process of coordinating flow of goods, services, and information among members of the supply chain.