The join in which tuples are joined based on values of a common attribute……
a) theta join
b) equi join
c) natural join
d) outer join
The join in which tuples are joined based on values of a common attribute appear only once..
a) theta join
b) equi join
c) natural join
d) outer join
Which of the following join, all tuples of left and right relations
is part of output?
a) theta join
b) equi join
c) natural join
d) outer join
How many types of outer join?
a) one
b) two
c) three
d) four
Explanation: left outer join, right outer join, full outer join
Which of the following join all tuples of left hand relation and only matching tuples from right hand relation?
a) left outer join
b) right outer join
c) full outer join
d) all of these
Which of the following join all tuples of right hand relation and only matching tuples from left hand relation?
a) left outer join
b) right outer join
c) full outer join
d) all of these
