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.

相关问题推荐

• Which three statements describe how the strict SQL mode provides added security?（）

  A

  It rejects statements that try to insert out-of-range values

  B

  It rejects invalid dates

  C

  It limits the operations that the server can perform

  D

  It rejects queries that produce out-of-range values

  E

  It rejects dates with zero day or month values

  查看答案

• Which of the following is an invalid subnet mask?（）

  A、255.0.0.0

  B、255.256.255.0

  C、255.255.255.255

  D、255.255.00

  查看答案

• 为了在法律上可行，以下所有的内容在合同中必须明确规定，除了（）。

  A、法定资格

  B、双方同意

  C、合适的合同形式

  D、定价

  查看答案

• A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）

  A、Alias

  B、View

  C、Schema

  D、Trigger

  查看答案

• User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

  A、UPDATE pets…

  B、SELECT….FROM pets

  C、INSERT INTO pets…

  D、ALTER TABLE pets…

  查看答案