What does the AUTO_INCREMENT attribute do?
- A Automatically increases column width
- B Generates a unique sequential number for new rows
- C Automatically indexes the column
- D Increments all values in the column
Answer
Generates a unique sequential number for new rows
AUTO_INCREMENT is typically used on surrogate primary keys. Values are not reused after deletion and gaps are normal after rolled-back transactions.





