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.
C
You might also like to view...
One of the basic requirements for an instrument to be negotiable is that it must be payable:
A. to a specific person. B. "to order" or "to bearer." C. on fulfillment of a conditional promise. D. in cash or kind.
History (H) refers to the occurrence of events before the experiment
Indicate whether the statement is true or false
Answer the following statements true (T) or false (F)
1. A compromise between the structured and unstructured interview format is the semistructured interview. 2. A primary question introduces a topic in an interview, while a secondary question follows up, probing further into the response to the primary question. 3. Primary questions help gain complete and accurate information, and also establish a positive communication climate in the interview. 4. Directed questions are effective as persuasion tools.
According to Table 12-4, which presents a queuing problem with a constant service rate, on average, how many minutes does a customer spend in the service facility?
A) 0.375 minute B) 4 minutes C) 0.625 minute D) 0.25 minute E) None of the above