57
QuizMultiple Choice

Pivot Tables and Pivot Charts — Cumulative exam

Question 57 • Computer Applications - Office 2016 - EL3520 A

Which type of join is used to show all the entries in the table containing the primary key regardless of whether that ID has an entry in the second table?

Answer
A
left outer join
B
right outer join
C
inner join
D
self join

Explanation

A left outer join keeps every row from the table on the left, even when there is no matching ID in the second table. In that case, the columns from the second table are returned as NULL. So the correct choice is left outer join.

AI-written and checked against the verified answer.

Previous
Next