Which of the following is not true about surrogate keys?
A)They are identifiers that are supplied by the system,not the users.
B)They have no meaning to the users.
C)They are non-unique within a table.
D)They can be problematic when combining databases.

Question

Quizplus · Accepted Answer

Surrogate keys are designed to be unique identifiers generated by the system and have no meaning to users. They are typically used when there is no natural primary key or when using a composite key would be impractical. Surrogate keys should be unique within a table to ensure their referential integrity, and when combining databases, conflicts may arise if the same surrogate key values are used in different tables. Therefore, C is the statement that is not true about surrogate keys.

Which of the Following Is Not True About Surrogate Keys