IBM
C2020-930 · Question #2
C2020-930 Question #2: Real Exam Question with Answer & Explanation
The correct answer is B. Outer join. See the full explanation below for the reasoning.
Question
You have two data sets. One data set contains customer name and age information along with a customer ID. The second data set contains the customer ID along with address information. There are no addresses which do not belong to a customer, there are customers which have no address, and there are customers which have multiple addresses. Which type of join will display all customers who have no recorded address?
Options
- AInner join
- BOuter join
- CPartial outer join
- DAnti-join
Community Discussion
No community discussion yet for this question.