Multiple choice technology databases

Various buffers are internally managed by database buffer cache

  1. free buffers

  2. dirty buffers

  3. pinned buffers

  4. access buffers
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The database buffer cache internally manages three types of buffers: free buffers (available for use), dirty buffers (modified but not yet written to disk), and pinned buffers (currently being read or modified). Access buffers is not a standard buffer cache type. The buffer cache uses these states to manage data blocks efficiently and maintain data consistency.

Keep practicing — related questions