In which cases would you use an outer join?
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 only unmatched dat
Correct answer: Only when the tables have a primary key/foreign key relationship. The tables being joined have only matched dat
Explanation
Quick AnswerThe correct answer is Only when the tables have a primary key/foreign key relationship. The tables being joined have only matched dat because it directly addresses the core logic of Database Management.
Outer joins return matched and unmatched rows from one or both tables.