207 views

2 Answers

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

0 votes
0 votes
1 answer
1
mohit jain asked Jun 25, 2022
363 views
the materialization approach of query evaluation includes (from root to leaf) :(a) π, ∞, σ(b) π, σ, ∞(c) σ, π, ∞(d) σ, ∞, π
4 votes
4 votes
2 answers
2
admin asked Apr 1, 2020
1,930 views
Which of the following desired features are beyond the capability of relational algebra?Aggregate ComputationMultiplicationFinding transitive closureAll of the above
1 votes
1 votes
1 answer
3
admin asked Mar 30, 2020
2,092 views
Cross Product is aUnary OperatorTernary OperatorBinary OperatorNot an operator