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
Explanation
Quick AnswerThe correct answer is The tables being joined have both matched and unmatched dat because it directly addresses the core logic of Database Management.
Outer joins return matched and unmatched rows from one or both tables.