Multiple choice technology databases

Which is an ideal pool for transaction log cache?

  1. 2K

  2. 8K

  3. 16K

  4. 4K

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

4K (4096 bytes) is the ideal pool size for transaction log cache in this system. 2K is too small for efficient batching, while 8K and 16K are unnecessarily large for typical transaction log entries.