Multiple choice technology databases

Application reterieves data from database buffer cache is referred as

  1. Cache hit

  2. Cache miss

  3. Cache init

  4. Cache success
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A cache hit occurs when requested data is found in the database buffer cache, eliminating the need to read from disk. This is much faster than a cache miss, which requires reading from data files on disk. The buffer cache is part of the SGA and stores frequently accessed data blocks to improve performance.

Keep practicing — related questions