In which cases would you use an outer join? Select one: a. Only when the tables have a primary key/foreign key relationship. B. The tables being joined have only unmatched data. C. The tables being joined have only matched data. D. The tables being joined have not null columns. E. The tables being joined have both matched and unmatched data.
Answers
Answered by
1
Answer: D
The tables being joined have not null columns
Answered by
3
The correct answer to this question is option E) tables which have both unmatched and matched data.
Explanation:
An outer join is made at the time when records are involved in the results with no corresponding records on the join tables.
Even these records are considered as matched with NULL records thereby its involved in the main output. Thus, a user could use this outer join for seeing rows which will not meet the join condition.
Similar questions