PdfPrep.com

Which type of join will display all customers who have no recorded address?

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

Answer: D

Exit mobile version