每日一题-2021-11-23

[Lucifer三思而后行]

【单选题】

在Oracle中，序列customers_seq使用下面的语句创建： CREATE SEQUENCE customers_seq INCREMENT BY 1 START WITH 10 MAXVALUE 100 MINVALUE 10 CYCLE CACHE 5; 下面对序列venseq修改的语句，错误的是（ ）。

A、ALTER SEQUENCE customers_seq START WITH 1;

B、ALTER SEQUENCE customers_seq NOCACHE;

C、ALTER SEQUENCE customers_seq MAXVALUE 90;

D、ALTER SEQUENCE customers_seq NOMINVALUE;

[Lucifer三思而后行]

答案选 A！

【答案解析】
if you want to retain the original START WITH value, you must drop the sequence and re-create it with the original START WITH value and the new INCREMENT BY value.