A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10U

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
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

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply