The ____ options are used to determine whether Oracle10g 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

Quizplus · Accepted Answer

The CYCLE and NOCYCLE options determine whether Oracle10g should restart the sequence when the maximum or minimum value has been reached (CYCLE) or throw an error (NOCYCLE). The other options (B, C, and D) are not related to whether values should be reissued from a sequence.

The ____ Options Are Used to Determine Whether Oracle10g Should