Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?()
- A、The next value will be 0 and the sequence will never use the values 101 to 105.
- B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
- C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
- D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
正确答案:D
答案解析:有
微信扫一扫手机做题