Question

What is key preserved table in Oracle?

Answer 1

A table is set to be key preserved table if every key of the table can also be the key of the result of the join. It guarantees to return only one copy of each row from the base table.