Multiple choice technology databases

Which process reads data from the data file into the database buffer cache ?

  1. Server process

  2. DBWR

  3. CKPT

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

When a query needs data that's not in the buffer cache, the server process reads it from the datafile on disk into the database buffer cache in memory. DBWR writes dirty buffers to disk (opposite direction), CKPT is the checkpoint process, and PMON monitors processes - none read data files into memory. This is fundamental Oracle memory architecture.

Keep practicing — related questions