Multiple choice

What is the difference between CYCLE/NO CYCLE in a oracle Sequence?

  1. For a cycle values for the column are regenerated MAXVALUE is reached.

  2. For a cycle values for the column are regenerated from MINVALUE once MAXVALUE is reached.

  3. For a no cycle values for the column are regenerated MAXVALUE is reached.

  4. For a no cycle values for the column are regenerated from MINVALUE once MAXVALUE is reached.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The CYCLE option causes a sequence to automatically restart at MINVALUE when MAXVALUE is reached, creating a cycle of values. NO CYCLE (the default) raises an error when MAXVALUE is exhausted. Option B correctly describes the CYCLE behavior; options A and C incorrectly describe regeneration at MAXVALUE without specifying the restart point.

Keep practicing — related questions