Exam C2090-930 topic 1 question 2 discussion

Actual exam question from IBM's C2090-930

Question #: 2
Topic #: 1

[All C2090-930 Questions]

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?

A. Inner join
B. Outer join
C. Partial outer join
D. Anti-join

Show Suggested Answer

Suggested Answer: C 🗳️

by SumitKmr at Oct. 2, 2019, 10:34 a.m.

Comments

Submit Cancel

Ashok21

11 months, 1 week ago

An Anti-join is the type of join that will display all customers who have no recorded address. An Anti-join returns only the rows from the left (or right) table where there is no match based on the specified condition. In this case, you would perform an Anti-join on the customer ID, selecting rows from the customer information dataset where there is no corresponding match in the address information datase

upvoted 1 times

...

SumitKmr

5 years, 2 months ago

Correct answere is "D"

upvoted 3 times

...

Exam C2090-930 All Questions

View all questions & answers for the C2090-930 exam

Exam C2090-930 topic 1 question 2 discussion

Comments

Ashok21

SumitKmr

SY0-701