_________________ operations do not preserve non-matched tuples.
A. Left outer join
B. Inner join
C. Natural join
D. Right outer join
Answer:B
_________________ operations do not preserve non-matched tuples.
A. Left outer join B. Inner join C. Natural join D. Right outer join
Explanation: Left outer join returns all the rows from the table that is on the left side and matching rows on the right side of the join. Inner join returns all rows when there is at least one match in BOTH tables. Natural join returns the common columns from the tables being joined. A right outer join returns all the rows from the table that is on the right side and matching rows on the left side of the join.