If the last values generated by a sequence were 277 and 278,which of the following changes cannot be initiated by the ALTER SEQUENCE command?
A) NOMAXVALUE
B) CYCLE
C) INCREMENT BY 5
D) MAXVALUE 200

Question

If the last values generated by a sequence were 277 and 278,which of the following changes cannot be initiated by the ALTER SEQUENCE command?​
A) ​NOMAXVALUE
B) ​CYCLE
C) ​INCREMENT BY 5
D) ​MAXVALUE 200

Quizplus · Accepted Answer

The ALTER SEQUENCE command can be used to change the NOMAXVALUE, CYCLE, and INCREMENT BY values of a sequence. However, setting the MAXVALUE to 200 would restrict the sequence to a maximum value of 200, which is lower than the current value of 278. Therefore, this change cannot be initiated by the ALTER SEQUENCE command.

If the Last Values Generated by a Sequence Were 277