What is a surrogate key in database design ?

2026

What is a surrogate key in database design ?

  1. A.

    A natural key from the data

  2. B.

    A system-generated unique identifier

  3. C.

    A composite key

  4. D.

    A foreign key reference

Attempted by 135 students.

Show answer & explanation

Correct answer: B

A surrogate key is a system-generated unique identifier used in database design, distinct from natural keys.

Explore the full course: Niacl Ao It Specialist