Multiple choice technology databases

Which memory area is used to cache the data dictionary information?

  1. Database Buffer Cache

  2. Redo Log Buffer

  3. Shared Pool

  4. PGA
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Shared Pool contains the data dictionary cache (row cache), which caches metadata information about tables, columns, and privileges. The Database Buffer Cache holds actual data blocks, the Redo Log Buffer caches transaction recovery info, and the PGA holds private session and SQL execution work areas.

Keep practicing — related questions