Which type of key is generated by the database system and has no direct business meaning?

Options

  • A. Natural key
  • B. Surrogate key
  • C. Foreign key
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Surrogate key

Detailed Explanation

  • Surrogate key: An artificial identifier generated for uniquely identifying records.
  • Example: An automatically generated numeric ID.
  • It has no direct business meaning and is commonly used as a primary key.