
Ultimate access to all questions.
A data engineer needs to join two tables, customers and orders, on the condition c.customer_id = o.order_customer_id. The goal is to retrieve details of all customers, including those who have not placed any orders, along with the details of orders they have placed. Given the schemas of both tables, which join operation should be used to achieve this?_
A
RIGHT OUTER JOIN
B
INNER JOIN
C
FULL OUTER JOIN
D
LEFT OUTER JOIN
E
Either LEFT OUTER JOIN or RIGHT OUTER JOIN can be used