Data Models into Database Designs

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).



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.