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.
an error
B.
100
C.
1
D.
10
Why “C”?
the “C” is a valid answer.
Try do it yourself, it’s easy.