When creating a sequence,which of the following is not an optional clause?
A) INCREMENT BY value
B) CYCLE | NOCYCLE
C) MAXVALUE value | NOMAXVALUE
D) CREATE SEQUENCE

Question

When creating a sequence,which of the following is not an optional clause?​
A) ​INCREMENT BY value
B) ​CYCLE | NOCYCLE
C) ​MAXVALUE value | NOMAXVALUE
D) ​CREATE SEQUENCE

Quizplus · Accepted Answer

The mandatory clause when creating a sequence is "CREATE SEQUENCE". The other options listed are optional clauses that can be used to further define the behavior of the sequence. Therefore, the option that is not an optional clause is D, "CREATE SEQUENCE".

When Creating a Sequence,which of the Following Is Not an Optional