多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题