Recent questions tagged natural-join

1 votes
1 answer
31
What will be the output of Natural Join if there is(are) common attribute(s) in two relations but no common value in these common attribute(s) ?for exampleTable RAB6971Ta...
3 votes
2 answers
32
What will be the output of Natural join if there is(are) common attribute(s) in two relations but no Common value in these common attribute(s) ?For example Table RAB9769T...
4 votes
4 answers
34
0 votes
1 answer
36
If there are no attributes in common between two relations R and S then, what should be the result of (R natural join S)?1) R x S2) $\phi$I think option 2 because of foll...
0 votes
1 answer
37
2 votes
1 answer
38
0 votes
0 answers
40
5 votes
2 answers
44
0 votes
1 answer
46
Comment on the following two statementsNatural Join produce cartecian product of two tables on joing two relations with no matching coloumsFull Outer Join produce cartec...
8 votes
1 answer
47
Let us consider 3 relations R1(ABD), R2(BCE) and R3(CF). The primary keys of R1 , R2 and R3 are A, B and C respectively. The number of tuples in R1, R2 and R3 are 50,4...
3 votes
2 answers
48
Consider the relation R1( P, Q, R, S ) and R2 ( R, G, T, U )The relation R1 has 20 tuples and R2 has 10 tuples then maximum number of tuples in R1 ⟕ R2 is ...........
1 votes
2 answers
49
1 votes
3 answers
50
1 votes
2 answers
51
Given answer for this question is:Should last row be present in the result. Please check