The join operation can be defined as
(A) a cartesian product of two relations followed by a selection
(B) a cartesian product of two relations
(C) a union of two relations followed by cartesian product of the two relations
(D) a union of two relations
Answer: (A)
Explanation: A SQL Join statement is used to combine data or rows from two or more tables based on the selection of common field between them. Different types of Joins are:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
So, option (A) is correct.
Quiz of this Question
Article Tags :
Recommended Articles