Register

TNPSC 2017

263 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….

 

 

 

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

438
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
438 views
TNPSC 2017
the materialization approach of query evaluation includes (from root to leaf) :(a) π, ∞, σ(b) π, σ, ∞(c) σ, π, ∞(d) σ, ∞, π
User Avatar
2.1k
views
2 answers
4 votes
admin asked Apr 1, 2020
2,059 views
NIELIT 2017 OCT Scientific Assistant A (IT) - Section B: 27
Which of the following desired features are beyond the capability of relational algebra?Aggregate ComputationMultiplicationFinding transitive closureAll of the above
User Avatar
2.2k
views
1 answers
1 votes
admin asked Mar 30, 2020
2,229 views
NIELIT 2017 July Scientist B (IT) - Section B: 54
Cross Product is aUnary OperatorTernary OperatorBinary OperatorNot an operator
User Avatar
2.5k
views
4 answers
4 votes
go_editor asked Mar 24, 2020
2,461 views
UGC NET CSE | January 2017 | Part 3 | Question: 9
Let $pk(R)$ denotes primary key of relation $R$. A many-to-one relationship that exists between two relations $R_1$ and $R_2$ ... $pk(R_1)\rightarrow R_1 \cap R_2$
User Avatar
Link Copied!