Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

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

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!