Solution

The correct answer is Option 2

Key PointsA "Right Outer Join" is a concept from SQL (Structured Query Language), used in relational databases. It's a method of combining two tables based on a common column between them, showing all records from the 'right' table and matched records from the 'left' table.

The result of a right outer join contains all the records from the right table and any records in the left table that match the join condition. For the records in the right table that do not have a corresponding match in the left table, the result is NULL in the columns of the left table.