Which case will require a sequence to be dropped and recreated instead of being modified
by the ALTER SEQUENCE statement?
A.
Change the increment between future values.
B.
Change the data type of the sequence
C.
Establish new minimum or maximum values.
D.
Reset the sequence to its starting value.
B)
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0060739.html
The data type of a sequence cannot be changed. Instead, you must drop the current sequence and then create a sequence specifying the new data type.
The attributes of the sequence that can be modified include:
Changing the increment between future values
Establishing new minimum or maximum values
Changing the number of cached sequence numbers
Changing whether the sequence cycles or not
Changing whether sequence numbers must be generated in order of request
Restarting the sequence
0
0