Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1
START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The SEQ1
sequence has generated numbers up to the maximum limit of 200. You issue the following
SQL statement: SELECT seq1.nextval FROM dual; What is displayed by the SELECT
statement?
A.
1
B.
10
C.
100
D.
an error
Explanation:
Answer is correct
http://stackoverflow.com/questions/26036660/sequence-starts-with-1-after-reaching-maxvalue-even-startwith-100-specified
http://www.aiotestking.com/oracle/what-is-displayed-by-the-select-statement/