In a Sequence, what is the purpose of CYCLE?

Options
- Specifies the sequence generates integers even after reaching its maximum or minimum value
- Specifies the sequence generates integers only after reaching its maximum or minimum value
- Specifies the sequence cannot generate any more integers after reaching its maximum or minimum value
- Both a and b


CORRECT ANSWER : Specifies the sequence generates integers even after reaching its maximum or minimum value

Discussion Board
Sequence

Sequence is a feature supported by some database systems to produce unique values on demand.

Syntax:
CREATE Sequence sequence-name
start with initial-value
increment by increment-value
maxvalue maximum-value
cycle|nocycle

where,

initial-value specifies the starting value of the Sequence.
increment-value is the value by which sequence will be incremented.
maxvalue specifies the maximum value until which sequence will increment itself.
Cycle specifies that if the maximum value exceeds the set limit, sequence will restart its cycle from the begining.
No cycle specifies that if sequence exceeds maxvalue an error will be thrown.

Prajakta Pandit 02-14-2017 04:26 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement