Oracle
1Z0-061 · Question #318
You create a sequence as follows: create sequence seq1 start with 1; After selecting from it a few times, you want to reinitialize it to reissue the numbers already generated. How can you do this?…
The correct answer is A. You must drop and re-create the sequence. See the full explanation below for the reasoning.
Question
You create a sequence as follows:
create sequence seq1 start with 1; After selecting from it a few times, you want to reinitialize it to reissue the numbers already generated. How can you do this? (Choose the best answer.)
Options
- AYou must drop and re-create the sequence.
- BYou can't. Under no circumstances can numbers from a sequence be reissued once they have
- CUse the command ALTER SEQUENCE SEQ1 START WITH 1; to reset the next value to 1.
- DUse the command ALTER SEQUENCE SEQ1 CYCLE; to reset the sequence to its starting value.
How the community answered
(25 responses)- A80% (20)
- B4% (1)
- C12% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.