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.
Correct Answer:

Verified
Correct Answer:
Verified
Q85: Triggers can be used to ensure referential
Q86: In SQL, a(n) _ subquery is a
Q87: A routine is a named set of
Q88: A procedure is run by calling it
Q89: What is a derived table? When is
Q90: SQL allows one to calculate linear regressions,
Q92: One major advantage of the outer join
Q93: The following query will execute without errors.<br>SELECT
Q94: EXISTS will take a value of _
Q95: Correlated subqueries are less efficient than queries