Database-Management-System
August 29, 2024UGC NET CS 2015 June Paper-3
August 29, 2024Database-Management-System
| Question 444 |
Given two tables R1(x, y) and R2(y, z) with 50 and 30 number of tuples respectively. Find maximum number of tuples in the output of natural join between tables R1 and R2 i.e. R1 * R2? (*. Natural Join)
| 30 | |
| 20 | |
| 50 | |
| 1500 |
Question 444 Explanation:
For this question one should understand the meaning of natural join.
NATURAL JOIN requires that the two join attributes (or each pair of join attributes) have the same name in both relations.
Let us take a small example where we are having two relations named Employee(EID, Ename) and Department(EID, DID)
Since relation R2 is having 30 tuples, so in best case natural join of R1 and R2 will 30 tuples.
NATURAL JOIN requires that the two join attributes (or each pair of join attributes) have the same name in both relations.
Let us take a small example where we are having two relations named Employee(EID, Ename) and Department(EID, DID)
Since relation R2 is having 30 tuples, so in best case natural join of R1 and R2 will 30 tuples.
Correct Answer: A
Question 444 Explanation:
For this question one should understand the meaning of natural join.
NATURAL JOIN requires that the two join attributes (or each pair of join attributes) have the same name in both relations.
Let us take a small example where we are having two relations named Employee(EID, Ename) and Department(EID, DID)
Since relation R2 is having 30 tuples, so in best case natural join of R1 and R2 will 30 tuples.
NATURAL JOIN requires that the two join attributes (or each pair of join attributes) have the same name in both relations.
Let us take a small example where we are having two relations named Employee(EID, Ename) and Department(EID, DID)
Since relation R2 is having 30 tuples, so in best case natural join of R1 and R2 will 30 tuples.