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:

Metacognition

The recognition and comprehension of an individual's own cognitive activities, commonly described as "thinking about thinking."

Reflect on your Own Thinking

The meta-cognitive process of analyzing one’s own thoughts, beliefs, and cognitive processes.

Zone of Proximal Development

A concept in developmental psychology referring to the difference between what a learner can do without help and what they can achieve with guidance and encouragement from a skilled partner.

Lev Vygotsky

A psychologist known for his work on cognitive development, particularly the social development theory which emphasizes the influence of social interactions on learning and development.