IBM
C2090-610 · Question #39
Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?
The correct answer is A. Change the data type of the sequence. See the full explanation below for the reasoning.
Question
Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?
Options
- AChange the data type of the sequence.
- BReset the sequence to its starting value.
- CEstablish new minimum or maximum values.
- DChange the increment between future values.
How the community answered
(17 responses)- A82% (14)
- B12% (2)
- D6% (1)
Community Discussion
No community discussion yet for this question.