A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10U
Posted: Fri Aug 26, 2022 9:58 am
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. 5
B. 10
C. 20
D. 30