profile-img
Eduncle posted an MCQ
February 22, 2020 • 16:31 pm 0 points
  • 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
  • comment-profile-img>
    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 in best case natural join of R1 and R2 will 30 tuples.

whatsapp-btn

Do You Want Better RANK in Your Exam?

Start Your Preparations with Eduncle’s FREE Study Material

  • Updated Syllabus, Paper Pattern & Full Exam Details
  • Sample Theory of Most Important Topic
  • Model Test Paper with Detailed Solutions
  • Last 5 Years Question Papers & Answers