easy5 pts · first answer countsdata-modellingpostgresql

Gaps in auto-increment IDs

A developer reports that IDs from an identity column jumped from 1041 to 1043. What is the most likely explanation?

A.A row with id 1042 was corrupted and must be repairedB.The sequence wrapped around and restartedC.Indexes skip numbers to save spaceD.An insert used 1042 and then rolled back or failed; sequence values are never reused

← Why InnoDB over MyISAM Storing event times →