Which option is used to have Oracle11g 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

Quizplus · Accepted Answer

The CACHE option in Oracle11g is used to have the database pre-generate a set of sequence values and store them in memory. This can improve performance by reducing the amount of I/O needed to generate new sequence values. The CACHE option can be used in combination with other options such as INCREMENT BY to further optimize sequence performance. Therefore, the correct option is C - CACHE.

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