43. 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
通过上面序列创建语句可以知道,该序列是循环的,不且没有定义MinValue,所以默认的最小值为1,当序列达到最大值后,就会从新从1开始。故此题选A。
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
通过上面序列创建语句可以知道,该序列是循环的,不且没有定义MinValue,所以默认的最小值为1,当序列达到最大值后,就会从新从1开始。故此题选A。