Question

In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of ____________________ keys.

Answer 1

In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of surrogate keys.

Explanation:

A surrogate key is a unique identity as an object or entity. It is used as an object in the database and as an entity in the modern world. Surrogate key is not a natural key hence it cannot be derived from application data.

Advantages of using surrogate key:

• They are unique
• They have uniform rules
• It allows unlimited values
• It stands the test of time