March 27, 2026 at 12:00 am
Comments posted to this topic are about the item Identities and Sequences II
March 27, 2026 at 8:10 am
The correct answer is 'Neither' because the identity column can be reseeded; therefore, a continuous sequence is not guaranteed.
March 27, 2026 at 1:11 pm
The identity is is not "restored" to its previous value when a transaction is rollback. There will be gaps here too.
I agree that "Neither" is the correct answer.
March 27, 2026 at 3:46 pm
I third the previous two comments.
March 30, 2026 at 7:40 am
In addition to the previous comments, the default for both is for the generated values to be cached in memory. If the server restarts at any point, there will almost always be a gap in the generated values due to the cached values being lost.
Possibly just a badly-worded question, but as written, "neither" is the only possible answer.
March 30, 2026 at 8:19 am
And I fourth comments two and three.
April 1, 2026 at 7:47 pm
I've reworded the question. Guarantee isn't a good word. Reseeding isn't something I'd say is valid, since this is a purposeful break (either intentionally or unintentionally).
Caching/restarts are outside of the scope, but I've noted this in the question.
points awarded back
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply