Exam 1z0-071 All QuestionsBrowse all questions from this exam
Go to Exam
Question 168

Examine these statements and the result:

Now examine this command:

What must replace MISSING CLAUSE for CUSTOMER_SEQ.NEXTVAL to return 11?

    Correct Answer: B

    To make the sequence increment by 10 so that the next value returned by CUSTOMER_SEQ.NEXTVAL is 11, the correct clause to use is 'INCREMENT BY 10'. When the sequence is altered with this clause, the NEXTVAL will be incremented by 10 from the current value of 1, resulting in the next value being 11.

Discussion
yaya32Option: B

I think B is correct

jm9999Option: B

Tested.

RamuneleOption: B

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

Arth1989Option: B

Tested twice. B

IzzicertificacionOption: C

CORRECT C, FALSE B