In which two cases would you use an outer join? (choose two.) a. The columns being joined have null values. B. The tables being joined have both matched and unmatched data. C. The tables being joined have not null columns. D. The tables being joined have only matched data.
Answers
Answer:
according to me the answer should be B and C
but not sure
#followme
#markasbrainlist
...
The column being joined will have null value and also the table joined have matched and unmatched data have an outer join.
Option A and Option B are the two cases to use an outer join.
Explanation:
OUTER JOIN is utilized for returning data from all rows from both the joined tables that satisfy JOIN condition and return all data from the rows which does not satisfy the same JOIN condition.
The OUTER JOIN should be used utilized within the JOIN condition only. As, in some cases, some of the columns might have null values. In that case, also, OUTER JOIN can be utilized. The joined fields alone should be the same so that it will join the table with both the matched and unmatched data.