Multiple choice technology databases

Shared Pool comprises of following components.

  1. Library Cache

  2. Data Buffer Cache

  3. Data Dictonary Cache

  4. SQL buffer cache
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

The Shared Pool in the SGA contains the Library Cache (which stores parsed SQL and PL/SQL) and the Data Dictionary Cache (which caches data dictionary information). The Data Buffer Cache is a separate SGA component for caching data blocks. SQL buffer cache is not a standard Oracle term - the Library Cache handles SQL caching.

Keep practicing — related questions