A candidate key for a database table can change often as long as it is unique.

Name: A candidate key for a database table can change often as long as it is unique.
Brand: Quizplus
Rating: 4.9 (30 reviews)

Question

Quizplus · Accepted Answer

A candidate key should remain unique and stable over time, representing an attribute or combination of attributes that identify a unique record in the table. If a candidate key changes frequently, it can lead to data inconsistencies and problems with referential integrity or indexing.

A Candidate Key for a Database Table Can Change Often