SQL (Structured Query Language) Question:
Download Questions PDF

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.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Where the integrity constraints are stored in data dictionary?How will you activate/deactivate integrity constraints?