The ____ options are used to determine whether Oracle12c should begin reissuing values from the sequence once the minimum or maximum value has been reached.
A) CYCLE | NOCYCLE
B) MINIMUMVALUE | MAXIMUMVALUE
C) CACHE | NOCACHE
D) REORDER | NOREORDER

Question

​The ____ options are used to determine whether Oracle12c should begin reissuing values from the sequence once the minimum or maximum value has been reached.
A) ​CYCLE | NOCYCLE
B) ​MINIMUMVALUE | MAXIMUMVALUE
C) ​CACHE | NOCACHE
D) ​REORDER | NOREORDER

Quizplus · Accepted Answer

The CYCLE and NOCYCLE options are used to determine whether Oracle12c should begin reissuing values from the sequence once the minimum or maximum value has been reached. If CYCLE is specified, then Oracle12c will begin reissuing values from the beginning of the sequence once the maximum has been reached. If NOCYCLE is specified, then Oracle12c will raise an error if an attempt is made to exceed the maximum or minimum value of the sequence.

​The ____ Options Are Used to Determine Whether Oracle12c Should

The ____ Options Are Used to Determine Whether Oracle12c Should