in Databases
57 views
0 votes
0 votes
___________ operator is used to retain the unmatched rows of relations when they joined.

(a) Outer Join

(b) Inner Join

(c) Natural Join

(d) Self Join
in Databases
57 views

2 Answers

0 votes
0 votes
Option (a) outer join
0 votes
0 votes

@mohit+jain

 

(a) Outer Join ….

 

A set of operations called outer join, can be used when we want to keep all the tuples in R or all those in S or all those in both relations in the result of JOIN ….

regardless of whether or not they have matching tuples in other relation….

 

 

 

Related questions