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:

Research

The organized examination and analysis of materials and sources to discover facts and form new conclusions.

Discriminant Validity

A measure of the degree to which a construct is truly distinct from other constructs by correlating minimally or not at all with measures from which it is theoretically supposed to differ.

IQ

An abbreviation for Intelligence Quotient, it's a measure of a person's reasoning ability compared to the statistical norm or average for their age, taken as 100.

Mode

A statistical term that refers to the most frequently occurring number found in a set of numbers.