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
0
0
Which part you don’t understand? Which option did you choose?
0
0
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!!!
0
0
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
0
0
Hi Kim, did you find the answer? What to study as I am in same boat as you at the moment.
0
0
(INNER) JOIN: Returns records that have matching values in both tables
LEFT (OUTER) JOIN: Return all records from the left table, and the matched records from the right table
RIGHT (OUTER) JOIN: Return all records from the right table, and the matched records from the left table
FULL (OUTER) JOIN: Return all records when there is a match in either left or right table
The results include:
All customers and their orders
Customers who have no orders
So this is either a LEFT JOIN (but thats not an answer, and I guess there are no order without a customer). Or an FULL Outer join, so the answer must be D.
7
0