Dell-EMC
E20-007 · Question #27
You have two tables of customers in your database. Customers in cust_table_1 were sent an e- mail promotion last year, and customers in cust_table_2 received a newsletter last year. Customers can…
The correct answer is D. Full outer join. See the full explanation below for the reasoning.
Question
You have two tables of customers in your database. Customers in cust_table_1 were sent an e- mail promotion last year, and customers in cust_table_2 received a newsletter last year. Customers can only be entered in once per table. You want to create a table that includes all customers, and any of the communications they received last year. Which type of join would you use for this table?
Options
- ACross join
- BInner join
- CLeft outer join
- DFull outer join
How the community answered
(18 responses)- A6% (1)
- C11% (2)
- D83% (15)
Community Discussion
No community discussion yet for this question.