Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seql -START WITH 100 -INCREMENT BY 10 -MAXVALUE 200 -CY
Posted: Wed Jun 07, 2023 6:11 am
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
A. 1
B. 10
C. 100
D. an error