Which of the following is a characteristic of a sequence?
A.
A sequence will never generate duplicate values.
B.
The MAXVALUE of a sequence can be equal to the MINVALUE.
C.
It is not possible to create a sequence that generates a constant since the INCREMENT value
must be greater than zero.
D.
When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal
to the specified value of either of these two boundaries.
A is wrong. When CYCLE is in effect, duplicate values can be generated by the sequence.
0
0
MINVALUE numeric-constant
Specifies the numeric constant that is the minimum value. This value can be any positive or negative value that could be assigned to a column of the data type associated with the sequence (SQLSTATE 42815), without nonzero digits existing to the right of the decimal point (SQLSTATE 428FA), but the value must be less than or equal to the maximum value (SQLSTATE 42815).
MAXVALUE numeric-constant
Specifies the numeric constant that is the maximum value. This value can be any positive or negative value that could be assigned to a column of the data type associated with the sequence (SQLSTATE 42815), without nonzero digits existing to the right of the decimal point (SQLSTATE 428FA), but the value must be greater than or equal to the minimum value (SQLSTATE 42815).
INCREMENT BY numeric-constant
Specifies the interval between consecutive values of the sequence. This value can be any positive or negative value that could be assigned to a column of the data type associated with the sequence (SQLSTATE 42815). The value must not exceed the value of a large integer constant (SQLSTATE 42820) and must not contain nonzero digits to the right of the decimal point (SQLSTATE 428FA).
If this value is negative, this is a descending sequence. If this value is 0 or positive, this is an ascending sequence. The default is 1.
0
0