Multiple choice

Which of the following memory areas is used to cache the data dictionary information?

  1. Database Buffer Cache

  2. PGA

  3. Redo Log Buffer

  4. Shared Pool
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Shared Pool in the SGA (System Global Area) caches data dictionary information, including table definitions, user privileges, and other metadata. This cache is frequently accessed by SQL parsing and execution. The Database Buffer Cache stores actual data blocks, PGA is for session-specific memory, and the Redo Log Buffer holds transaction log entries before they're written to redo log files.

Keep practicing — related questions