Question: What does a `RIGHT JOIN` ensure?

1. that only records from the rightmost table will be displayed
2. that no records from the rightmost table are displayed if the records dont have corresponding records in the left table
3. that records from the rightmost table will be displayed only if the records have a corresponding value in the leftmost table
4. that all records from the rightmost table are represented in the result, even if there are no corresponding records in the left table

Answer: The correct answer of the above question is Option D:that all records from the rightmost table are represented in the result, even if there are no corresponding records in the left table