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:
Good question!
CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE;
Sequence SEQ1 criado.
SELECT seq1.nextval FROM dual;
NEXTVAL
———-
100