A(n) ____ table is one that is involved in a join and the keys of the original table are included in the keys of the resultant join.
A) mutating
B) system
C) database
D) key-preserved

Question

Quizplus · Accepted Answer

A key-preserved table is one that retains its original keys after joining with another table. This means that the original keys are included in the keys of the join result, which allows for the preservation of the unique rows from the original table. Mutating and system tables are not relevant to the concept of join keys, and while a database may contain key-preserved tables, it is not a term specific to databases.

A(n) ____ Table Is One That Is Involved in a Join