Taylor Manages a Database for a Regional Hardware Enterprise with 10

question 39

Multiple Choice

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:

Legal Entity

An organization or business that is given legal rights and responsibilities, including the ability to enter into contracts, sue, and be sued.

Economic Order Quantity

Economic Order Quantity (EOQ) is a formula used in inventory management to determine the optimal order size that minimizes the total cost of holding and ordering inventory.

Total Expenses

The sum of all costs and expenses associated with operating a business or executing a project.

Profit

The financial gain obtained when the revenue from selling goods or services exceeds the costs associated with production and distribution.