Question 520
Two audit tables need distinct identifiers drawn from one centrally managed number generator. Which implementation step most directly addresses this requirement?
Explanation
Correct Answer
A SEQUENCE object can provide values independent of a single table's IDENTITY property. Create a reviewed shared SEQUENCE with suitable type, increment and permissions. New records from both writers receive valid numbers from the shared sequence.
Incorrect Answers
Separate IDENTITY columns cannot guarantee a central audit record key across tables. Use a reviewed shared SEQUENCE or coordinated allocator.
CYCLE can reuse numbers and allocation is not a uniqueness constraint. Review sequence bounds and shared key validation.
SEQUENCE gaps do not justify dropping key constraints. Preserve audit identifier integrity and separate the gap-tolerance policy.