移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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

发布日期:2022-06-26

Given the following ALTER SEQUENCE statement: ALTE...
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.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!