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
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:
So, option (A) is correct.
Quiz of this Question
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.