Multiple choice technology databases

The identity value will be rolled back when the transaction that tried to insert the value into the table is not committed or rolled back

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Identity values generated during an insert operation are not rolled back if the transaction fails or is rolled back. This behavior prevents serialization bottlenecks and ensures high performance, though it can leave gaps in the sequence.

Keep practicing — related questions