ISRO | ISRO CS 2008 | Question 31
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
Last Updated :
12 Jun, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...