Oracle
1Z0-061 · Question #318
1Z0-061 Question #318: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #318. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.