Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?
A) INTERVAL STORE
B) CACHE VALUE
C) CACHE
D) INCREMENT BY

Question

​Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?
A) ​INTERVAL STORE
B) ​CACHE VALUE
C) ​CACHE
D) ​INCREMENT BY

Quizplus · Accepted Answer

The option used to have Oracle12c pre-generate a set of values and store those values in the server's memory is CACHE. This improves performance by reducing the number of round-trips to the server for generating new values. INTERVAL STORE and INCREMENT BY are options used to specify the interval between values generated by a sequence. CACHE VALUE is not a valid option.

​Which Option Is Used to Have Oracle12c Pre-Generate a Set

Which Option Is Used to Have Oracle12c Pre-Generate a Set