Final answer:
The purpose of a full outer join is to include all records from both joined tables, covering both matching (commonalities) and non-matching (orphan) records from each table.
Step-by-step explanation:
The purpose of a full outer join is to combine records from two or more tables in a database by including all records from both tables, not just the ones with matching values in their common fields. This means it includes the commonalities (matching records) as well as orphan records (non-matching records) from both tables. Hence, option 1 is correct: To include commonalities and orphan records from both sides. For example, if we have two tables,
Table A and Table B, and we perform a full outer join on them, the resulting table will contain all records where there is a match in both tables, as well as all records from Table A that have no match in Table B and vice versa.A full outer join is used to include both the matching and non-matching records from both sides of the join. This means that records from both tables will be included in the result set, regardless of whether they have a match in the other table.For example, if we have two tables: Customers and Orders, a full outer join will include all customers and orders, including those that do not have matches. This can be useful when you want to combine data from two tables and include all the records, including the ones that do not have a match.