Which two cases would you use an outer join?

By: Answerout


Here is the solution for Which two cases would you use an outer join?. The solution is given after the options.

Which two cases would you use an outer join?

The tables being joined have NOT NULL columns.

The tables being joined have only matched data.

The columns being joined have NULL values.

The tables being joined have only unmatched data.

The tables being joined have both matched and unmatched data.

Only when the tables have a primary key/foreign key relationship.

Correct Answer

The columns being joined have NULL values. The tables being joined have both matched and unmatched data.

Explanation:

The columns being joined have NULL values. The tables being joined have both matched and unmatched data. is the answer for Which two cases would you use an outer join?

Conclusion:

are provided by Answerout to teach the newcomers in the Digital Marketing Industry. The answers provided are 100% correct and are solved by Professionals. We don’t and never have recommended using these answers as a cheat sheet. We keep updating our answers as the Exam Change. You can also send us an Email or Comment to notify us of any support or Changes.

comments
leave comment