SQL (Structured Query Language) Question:
What is CYCLE/NO CYCLE in a Sequence?
Answer:
CYCLE specifies that the sequence continue to generate values after reaching either maximum or minimum value. After pan-ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum.
NO CYCLE specifies that the sequence cannot generate more values after reaching its maximum or minimum value.
NO CYCLE specifies that the sequence cannot generate more values after reaching its maximum or minimum value.
| Previous Question | Next Question |
| Where the integrity constraints are stored in data dictionary? | How will you activate/deactivate integrity constraints? |