0 0 votes The number of tuples in the result of a left outer join operation will always be (A) greater than the number of tuples in the result of the corresponding join operation. (B) at least equal to the number of tuples in the result of the corresponding join operation. (C) less than the number of tuples in the result of the corresponding join operation. (D) greater than the number of tuples in the result of the corresponding right outer join operation. Databases databases relational-algebra + – mohit jain 1.0k views answer comment Share Follow Print See 1 comment 1 1 comment reply Vishnu__ commented Jul 21, 2022 reply Follow flag The answer is option (B). As when we perform left outer join, we may get more tuples present in corresponding relation. But if there are all matches w.r.t. the relations, then we get equal number of tuples as in left-relation. 0 0 replyShare Please log in or register to add a comment.
0 0 votes The answer is option (B). When we perform left outer join, we may get more tuples then in corresponding join operation because Left outer join includes all tuples of normal join operation + unmatched tuples of Left relation(null values in right relation attributes). So, Left outer join is at least equal to the number of tuples in the result of the corresponding join operation. aaaakash001 answered Oct 15, 2022 aaaakash001 comment Share Follow 0 reply Please log in or register to add a comment.
