UGC NET
profile-img
Eduncle Asked an Mcq
February 22, 2020 11:01 am
  • UGC NET
  • Computer Science & Applications

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)

Choose Your Answer:
  • 0 Attempts
Submit Now
  • 0 Likes
  • 1 Comments
  • 0 Shares
  • Eduncle Best Answer

    NATURAL JOIN requires that the two join attributes (or each pair of join attributes) have the same name in both relations. Relation R2 is having 30 tuples, which is minimum, so ...

    Show more
    Likes(0) Reply(0)
How Eduncle Helps You ?
StudentTutorInstitutionApp
Help
FAQsPayment TermsRefund PolicyAsk Support
Head Office :
MPA 44, 2nd floor, Rangbari main Road Mahaveer Nagar II, Kota (Raj.) - 324005

Branch Office (Jaipur):
Shyam Tower, Plot No. F2, 6th Floor Amrapali Circle,
Vaishali Nagar, Jaipur, Rajasthan 302021

Mail: info@eduncle.com
All Rights Reserved © Eduncle.com