In which cases would you use an outer join? Selectone: Seec o e: The tables being joined have only unmatched data. Only when the tables have a primary key/foreign key relationship. The tables being joined have only matched data. The tables being joined have both matched and unmatched data. The tables being joined have NOT NULL columns.
Answer options
A
Only when the tables have a primary key/foreign key relationship. The tables being joined have only matched dat
B
The tables being joined have both matched and unmatched dat
C
The tables being joined have NOT NULL columns.
Correct answer: The tables being joined have both matched and unmatched dat
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.