-
A.
It includes all the tuples from both the relations satisfying the join condition along with all the tuples in the right relation that do not have a corresponding tuple in the left relation.
-
B.
It includes all the tuples from both the relations satisfying the join condition along with all the tuples in the left relation that do not have a corresponding tuple in the right relation.
-
C.
It selects all the tuples satisfying the join condition along with the tuples for which no tuples from the other relation satisfy the join condition.
-
D.
None of these
Correct Option: AExplanation: It includes all the tuples from both the relations satisfying the join condition along with all the tuples in the right relation that do not have a corresponding tuple in the left relation.