Multiple choice

Which of the following statements is true with regard to the shared pool?

  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 accessed data definitions.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The shared pool stores the most recently executed SQL statements and the most recently accessed data definitions.

Keep practicing — related questions