What does the natural join operation do?

Question

TuteeHUB · Accepted Answer

It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations

TuteeHUB · Answer

It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations

TuteeHUB · Answer

It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations

TuteeHUB · Answer

It considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations

TuteeHUB · Answer

None of the mentioned

1.	What does the natural join operation do?
A.	It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations
B.	It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations
C.	It considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations
D.	None of the mentioned
Answer» B. It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations

Discussion