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:

Visual Aids

Tools such as charts, diagrams, videos, or models used to enhance the comprehension or retention of information by visual means.

Font Colors

Represent the variety of colors in which text can appear in a digital document or on a web page, used to enhance readability and design appeal.

Communication Medium

A tool or channel through which information and messages are conveyed from one entity to another.

Seriousness

The quality of being earnest, grave, or important in manner, thought, or expression.