db2 认证730 128题库中14题为什么选D,好心人帮我解释一下,谢谢。
db2 认证730 128题库中14题为什么选D,好心人帮我解释一下,谢谢。
www.ExamWorx.com Q: 14 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.sysdummy1
Which value will be returned by the query?
A. 20
B. 25
C. 50
D. 55
Answer: D
追问:最好是说明一下原理。
比如VALUES NEXT VALUE FOR my_seq INTO :con2hvar 时 my_seq的值