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:

Paralegals

Professionals in the legal field who assist attorneys by performing non-lawyer tasks such as documentation, research, and client communication, playing a critical role in the functioning of legal teams.

Washington

The capital city of the United States, located in the District of Columbia, or a state in the Pacific Northwest region of the United States.

Montana

A state located in the Northwestern United States, known for its varied terrain ranging from the Rocky Mountains to the Great Plains.

Voluntary Statewide Certification

A non-mandatory credentialing process within a state that recognizes an individual’s qualifications in a certain profession.