This topic contains 0 replies, has 0 voices, and was last updated by  EduGorilla 1 year, 11 months ago.

  • Author
    Posts
  • #1440495 Reply
     EduGorilla 
    Keymaster
    Select Question Language :


    Consider we have two relations R & S. Relation R contains three attributes: A, B and C, where A act as primary key. Relation S Consists of three attributes: A, D and E, where (A, D) act as primary key. Suppose both the relations have ‘n’ no of tuples. When natural join between R &S is performed, the resultant table has ‘m’ no of tuples. What is the range of no of tuples, when left outer join is performed between R & S, taking R as the left side table?

    Options :-

    1. 0 to n2
    2. n to 2n
    3. n to 2n-1
    4. m to 2n-1
    Post your Training /Course Enquiry
    Are You looking institutes / coaching center for
    • IIT-JEE, NEET, CAT
    • Bank PO, SSC, Railways
    • Study Abroad
    Select your Training / Study category
Reply To: Consider we have two relations R & S. Relation R contains three attributes: A, B and C, where A ….
Your information:




Verify Yourself




Log in with your credentials

or    

Forgot your details?

Create Account