Question: What is a surrogate key?

Options:

1. A natural key derived from the data
2. A key that is created for the purpose of uniquely identifying a record
3. A composite key made of multiple attributes
4. A foreign key that references another table

Correct Answer: A key that is created for the purpose of uniquely identifying a record

Solution:

A surrogate key is a key that is created for the purpose of uniquely identifying a record, often an auto-incremented number.