494 views
0 votes
0 votes
______ operation preserves those tuples that would be lost in____

(a) Natural join, Outer join

(b) Outer join, Natural join

(c) Left Outer Join, Right Outer Join

(d) Left Outer Join, Natural Join

1 Answer

0 votes
0 votes

(b) is the correct answer.

Outer join (Full outer join) preserves those tuples that would be lost in natural join.

Consider two relations

Relation 1:

A B
1 a
2 b
3 c

 

Relation 2:

B C
a 4
c 6

 

A ⋈ B

A B C
1 a 4
3 c 6

 

Full Outer JoinB

A B C
1 a 4
2 b NULL
3 c 6

 

Related questions

0 votes
0 votes
2 answers
1
mohit jain asked Jun 25, 2022
387 views
in relational databases, the natural join of two tables is(a) cartesian product always(b) combination of union and filtered cartesian product(c) combination of selection ...
27 votes
27 votes
3 answers
3
makhdoom ghaya asked Nov 8, 2015
3,206 views
In a relational database there are three relations:$Customers = C\textsf{(CName)}$,$Shops = S \textsf{(SName)}$,$Buys = B\textsf{(CName, SName)}$.Which of the following r...