PrepAway - Latest Free Exam Questions & Answers

Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE

Which case will require a sequence to be dropped and recreated instead of being modified
by the ALTER SEQUENCE statement?

PrepAway - Latest Free Exam Questions & Answers

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.

One Comment on “Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE

  1. db2man says:

    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

Leave a Reply