Data Models into Database Designs - Technical MCQs

Q1:

Which is not true about surrogate keys?

A They are short.

B They are fixed.

C They have meaning to the user.

D They are numeric.

ANS:C - They have meaning to the user.

Surrogate keys are keys that have no business meaning and are solely used to identify a record in the table. Such keys are either database generated (example: Identity in SQL Server, Sequence in Oracle, Sequence/Identity in DB2 UDB etc) or system generated values (like generated via a table in the schema).