一道有关序列号的SQL题目，请各位参考一下，不知道答案是哪个？单选

www_xylove

单选：
1. 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. 10
C. 100
D. an error

[ 本帖最后由 www_xylove 于 2009-10-20 15:05 编辑 ]

www_xylove

答案是A

renxiao2003

他到不了100，到191后就是1 了。

SQL> select seq1.nextval from dual;

   NEXTVAL
----------
       161

SQL> /

   NEXTVAL
----------
       171

SQL> /

   NEXTVAL
----------
       181

SQL> /

   NEXTVAL
----------
       191

SQL> /

   NEXTVAL
----------
         1