Multiple choice technology databases

Which statement about the shared pool is true?

  1. The shared pool CANNOT be dynamically resized.

  2. The shared pool contains only fixed structures

  3. The shared pool consists of the library cache and buffer cache.

  4. The shared pool stores the most recently executed SQL statements and the most recently
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The shared pool is a key component of the Oracle System Global Area (SGA) that caches SQL execution plans, PL/SQL code, and system parameters. It stores the most recently executed SQL statements and dictionary data. It does not contain the buffer cache, and it can be dynamically resized.

Keep practicing — related questions