You have a Customer table and an Order table. You join the Customer table with the Order table by
using the CusromerID column.
The results include:
All customers and their orders
Customers who have no orders
Which type of join do these results represent?
A.
Complete join
B.
Partial join
C.
Inner join
D.
Outer join
I will not understand
Which part you don’t understand? Which option did you choose?
Hello Olivia, I did not understand it to return all customers and Their orders the command would INNER JOIN now to return Customers who have no orders in my opinion the command would OUTER JOIN , understand?
I selected the otion INNER JOIN.
Thanks!!!
Is this just a practise test? Or are these actual questions on the test? Ahhhh I dont know what to study this version or the older version. HELpppp
Hi Kim, did you find the answer? What to study as I am in same boat as you at the moment.