Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seql
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:
SELECT seql.nextval FROM dual;
What is displayed by the SELECT statement?
A. 1
B. 10
C. 100
D. an error
I think 1 is the correct answer. the sequence will go to the minimum value at cycle, and with no minimum value specified, the default is 1. So correct answer is 1
100
Incorrect answer.
It will be 100
The correct answer is A.
Please, do it yourself. You will see it.