Why cache option used in sequences
-
To get automatic values
-
For esay access
-
For fast access
-
All of the above
C
Correct answer
Explanation
The CACHE option in Oracle sequences pre-allocates sequence values and keeps them in memory for faster access. This minimizes disk I/O when generating values. While the sequence generates automatic values, CACHE specifically optimizes speed.