可学答题网 > 问答 > IBM(000-730)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Given the following ALTER SEQUENCE sta


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?()

  • AThe next value will be 0 and the sequence will never use the values 101 to 105.
  • BThe next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
  • CPreviously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
  • DThe next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
参考答案
参考解析:
分类:IBM(000-730)题库