Register

DBMS Join | Test Series | MadeEasy

407 views
0 votes
0 votes

 

In relational databases, the natural join of two tables:

  1. Can be equivalent to cartesian product of these two tables
  2. Is combination of union and filtered cartesian product
  3. Is combination of selection and filtered cartesian product
  4. Is combination of projection and filtered cartesian product

 

MSQ

Please describe your choice(s).

User Avatar

1 Answer

1 votes
1 votes
  1. If No common Attribute between the relations, Natural join between those two relation is  equals to cross product.   
  2. False
  3. False
  4. R Natural Join S is combination of projection and filtered cartesian product.     So according to me a and d are correct.

      

        

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

Related questions

5 votes
5 votes
1 answer
1
Na462 asked Jun 14, 2018
4,254 views
MadeEasy Test Series: Databases - Natural Join
Consider a relation r1(A, B, C), r2(C, D, E) and r3(F, G) with primary keys A, C and F respectively. Assume that r1 has 150 tupples, r2 has 100 tupples and r3 has 75 tupples. The number of resultant tuple in are ________.
Consider a relation r1(A, B, C), r2(C, D, E) and r3(F, G) with primary keys A, C and F respectively. Assume that r1 has 150 tupples, r2 has 100 tupples and r3 has 75 tupp...
User Avatar
0 votes
0 votes
0 answers
2
aditi19 asked Nov 2, 2018
307 views
JOIN Doubt
in case of outer join for combining two tables, if there is no common attribute does it returns cartesian product just like natural join does?
in case of outer join for combining two tables, if there is no common attribute does it returns cartesian product just like natural join does?
User Avatar
1 votes
1 votes
0 answers
3
iarnav asked Nov 27, 2017
580 views
DBMS SELF DOUBT
Let R and S be two relations with the following schema R(P−−,Q−−,R1,R2,R3) S(P−−,Q−−,S1,S2) where {P,Q} is the key for both schemas? R:{⟨"1","abc","p1","p2","p3"⟩, ⟨"2","xyz", ... ;,"q3"⟩ ⟨"2","def","q1","q2","q3"⟩ WHat is R *S? WHERE * IS NATURAL JOIN.
Let R and S be two relations with the following schemaR(P−−,Q−−,R1,R2,R3)S(P−−,Q−−,S1,S2)where {P,Q} is the key for both schemas?R:{⟨"1","abc","p1","p2"...
User Avatar
0 votes
0 votes
5 answers
4
Pooja Khatri asked Jul 13, 2018
2,400 views
UGC NET CSE | July 2018 | Part 2 | Question: 61
In RDBMS, which type of Join returns all rows that satisfy the join condition? Inner Join Outer Join Semi Join Anti Join
In RDBMS, which type of Join returns all rows that satisfy the join condition?Inner JoinOuter JoinSemi JoinAnti Join
User Avatar
Link Copied!