UGC NET CS 2018 July - II Question 61

61. In RDBMS, which type of Join returns all rows that satisfy the join condition ?

(1) Inner Join
(2) Outer Join
(3) Semi Join
(4) Anti Join

Explanation:
Answer: (1) Inner Join

INNER JOIN:
The INNER JOIN of two or more tables returns only those rows that satisfy the join condition

OUTER JOIN:
An outer join returns all rows that satisfy the join condition and rows not matching for the table on the right/left/both side of join(RIGHT JOIN/ LEFT JOIN/FULL JOIN respectively).

Previous	Next
UGC NET CS 2018 July - II Question 60	UGC NET CS 2018 July - II Question 62