Open In App

ISRO | ISRO CS 2008 | Question 31

Like Article
Like
Save
Share
Report

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
Previous
Next
Share your thoughts in the comments
Similar Reads