单选题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 wil

题目

单选题

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?（）

The next value will be 0 and the sequence will never use the values 101 to 105.

The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

更多“单选题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 wil”相关问题

第1题

Which of the following is a characteristic of a sequence?（）A、A sequence will never generate duplicate valuesB、The MAXVALUE of a sequence can be equal to the MINVALUEC、It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD、When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

点击查看答案
第2题

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）A、After a ROLLBACK is issuedB、After the sequence is alteredC、After the sequence is droppedD、After the current session ends

点击查看答案
第3题

Which of the following is a feature of a unit of work?（）A、It applies to a single data server.B、It is a recoverable sequence of operations.C、Its value can be queried from the system catalog tables.D、It begins when the application connects to the data server.

点击查看答案
第4题

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）A、2B、3C、11D、30

点击查看答案
第5题

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）A、20B、25C、50D、55

点击查看答案
第6题

Which of the following privileges permits a user to update the comment on a sequence?（）A、CONTROLB、UPDATEC、USAGED、ALTER

点击查看答案
第7题

When performing an online backup，what is the proper order of the following steps？（） a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command. d. Back up the database files. e. Determine the beginning log sequence number. f. Determine the ending log sequence number. g. Force a log switch with the alter system switch logfile command.A、a， b， c， d， e， f， gB、c， d， a， b， e， g， fC、f， d， b， g， a， c， eD、e， c， d， a， g， f， bE、a， f， b， g， e， c， d

点击查看答案

IBM(000-730)

单选题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 wil

题目

更多“单选题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 wil”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容