Case-Based Critical Thinking Questions

question 32

Multiple Choice

Case-Based Critical Thinking Questions
Case 9-3
Taylor manages a database for a regional hardware enterprise with 10 stores in 2 states.  The hardware store wholesales to contractors. The database includes these tables (among others) : tblContractor, tblProducts, tblBilling, tblInvoices.
-Taylor wants to create a query that shows all contractors and identifies invoices assigned to those contractors.  However, he also wants to see contractors who might not have an invoice assigned for this billing period.  What type of join between tables will give Taylor the desired results?

• A)inner join
• B)outer join
• C)self-join
• D)many-to-many

---

Definitions:

Unique Goods

Products that are distinct in their characteristics, offering uniqueness that differentiates them from mass-produced items.

Price Discrimination

A strategy in pricing where the same provider sells identical or nearly identical products or services at varying prices across different markets.

Deadweight Loss

The reduction in total societal welfare resulting from market inefficiencies, typically due to taxes, subsidies, or monopolies.

Market Output

The total quantity of goods or services produced and offered for sale in a particular market.