3
AssignmentMultiple Choice

Joining Tables

Question 3 • DRHS-Business and Tech BLOCK (07.4410030)

What records will appear for a left outer join with a primary table called OrderItems and a foreign table called Orders?

Answer
A
all Orders records
B
all OrderItems records
C
only matching OrderItems records
D
all of the Orders and OrderItems records

Explanation

A left outer join keeps every record from the left, or primary, table and adds matching records from the other table when available. Since OrderItems is the primary table, all OrderItems records will appear, including those without a matching Orders record. The correct choice is “all OrderItems records.”

AI-written and checked against the verified answer.

Previous
Next