Multiple choice

What MySQL property is used to create a surrogate key in MySQL?

  1. UNIQUE

  2. SEQUENCE

  3. AUTO_INCREMENT

  4. None of the above -- Surrogate keys are not implemented in MySQL
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

AUTO_INCREMENT is the MySQL property used to create surrogate keys. It automatically generates a unique numeric value for each new row, typically used for primary key columns. UNIQUE is a constraint that ensures column values are distinct but doesn't auto-generate values. MySQL doesn't use SEQUENCE objects like some other databases (Oracle, PostgreSQL).

Keep practicing — related questions