Question 340
Two audit tables need distinct identifiers drawn from one centrally managed number generator. The team proposes this approach: Create a reviewed shared SEQUENCE with suitable type, increment and permissions. Which technical principle supports this approach?
Explanation
Correct Answer
A SEQUENCE object can provide values independent of a single table's IDENTITY property. Sequence-generated values are not gap-free and may be consumed on rollback.
Incorrect Answers
IDENTITY values belong to their respective tables; they do not coordinate a shared counter. A SQL SEQUENCE exists independently of the tables.
SEQUENCE numbers are consumed outside transaction commit. Rolled-back transactions can leave unused gaps in the sequence.
SQL SEQUENCE produces numbers, but cross-table uniqueness requires constraints or safeguards; CYCLE or reseeding can reuse values.