Skip to content
Related Articles

Related Articles

ISRO | ISRO CS 2008 | Question 31
  • Last Updated : 12 Jun, 2018

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

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.

My Personal Notes arrow_drop_up
Recommended Articles
Page :