Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seq1
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 seq1.nextval FROM dual;
What is displayed by the SELECT statement?
A) 1
B) 100
C) an error
D) 10
Answer：B
【OCP-12c】CUUG 071题库考试原题及答案解析（22）
原文：http://blog.51cto.com/13854012/2352422