A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10User USER1 successfullyexecutes the following statements in the order shown:VALUES NEXT VALUE FOR my_seq INTO :hvar;VALUES NEXT VALUE FOR my_seq INTO :hvar;User USER2 successfully executes the following statements in the order shown:ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5;VALUES NEXT VALUE FOR my_seq INTO :hvar;After users USER1 and USER2 are finished, user USER3 executes the following query:SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1What value will be returned by the query?
A. 5
B. 10
C. 20
D. 30
A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10U
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10U
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!