TESTED : Correct answer is B
NOCACHE --> NEXTVAL =2;
INCREMENT BY 10 --> NEXTVAL =11;
START WITH 11 --> ORA ERROR - CANNOT ALTER SEQUENCE STARTING NUMBER
MINVALUE 11 --> ORA ERROR - MINVALUE CANNOT BE MADE TO EXCEED THE CURRENT VALUE
CYCLE 11 --> ORA ERROR - SQL COMMAND NOT PROPERLY ENDED
I creating sequence - create sequence customer_seq cache 10;
What I get from alter sequence customer_seq:
A. NOCACHE – NEXTVAL 1
B. INCREMENT BY 10 - NEXTVAL 10.
C. START WITH 11 - ORA-02283: cannot alter starting sequence number
D. MINVALUE 11 - ORA-04007: MINVALUE cannot be made to exceed the current value
E. CYCLE 11 - ORA-00933: SQL command not properly ended
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
odi_USER
1 month, 4 weeks agoyaya32
9 months agoArth1989
9 months, 1 week agojm9999
1 year agoRamunele
1 year agoIzzicertificacion
1 year, 2 months ago