Database Management
primer-original-v2mediumDatabase Management7. Joins & Subqueryprimer-original-v2

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.

This question has been retained as-is due to its unique context.

Related Database Management questions

Practice more Database Management questions

PrimerPrep has independently reviewed practice questions and coding exercises — all free.