Multiple choice

Sequence values cannot be cached.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Sequence values CAN be cached. The CACHE clause in a sequence definition allows Oracle to pre-allocate sequence values in memory, which improves performance by reducing disk I/O. Without caching, each value must be written to disk. The default cache size is 20, and you can specify a larger value or use NOCACHE if needed.

Keep practicing — related questions