0 votes 0 votes ______ operation preserves those tuples that would be lost in____ (a) Natural join, Outer join (b) Outer join, Natural join (c) Left Outer Join, Right Outer Join (d) Left Outer Join, Natural Join Databases databases relational-algebra + – mohit jain asked Jun 25, 2022 mohit jain 494 views answer comment Share Follow See 1 comment See all 1 1 comment reply Vishnu__ commented Jul 21, 2022 reply Follow Share Always in outer join, the non-matching tuples are also preserved. But whereas in natural join only matching tuples are considered. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes (b) is the correct answer. Outer join (Full outer join) preserves those tuples that would be lost in natural join. Consider two relations Relation 1: A B 1 a 2 b 3 c Relation 2: B C a 4 c 6 A ⋈ B A B C 1 a 4 3 c 6 A B A B C 1 a 4 2 b NULL 3 c 6 Shoto answered Jul 8, 2022 Shoto comment Share Follow See all 0 reply Please log in or register to add a comment.