Multiple choice technology databases

Why cache option used in sequences

  1. To get automatic values

  2. For esay access

  3. For fast access

  4. All of the above

Reveal answer Fill a bubble to check yourself
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.