The left and right joins are also known as . . . . . . . .

Solution (By Examveda Team)

This question is about different ways to combine data from two tables in MySQL.
Think of it like combining two groups of friends to form a bigger group.
Left JOIN and Right JOIN are special types of OUTER JOINs.
Imagine you have two groups of friends, let's say "Group A" and "Group B". An OUTER JOIN lets you combine these groups while ensuring that all members from at least one of the groups are included in the final group.
Left JOIN keeps all members from "Group A" and adds matching members from "Group B". If there's no match for someone in "Group A", they still appear in the final group, but with empty information from "Group B".
Right JOIN works similarly but keeps all members from "Group B" and adds matching members from "Group A". If there's no match for someone in "Group B", they still appear in the final group, but with empty information from "Group A".
So the answer is Option C: OUTER JOIN.
INNER JOIN combines only matching members from both groups, like finding friends who are in both "Group A" and "Group B".
NATURAL JOIN is similar to INNER JOIN but automatically finds matching columns between the two groups.
CARTESIAN JOIN creates every possible combination of members from both groups, which is usually not what you want!