Multiple choice

Which of the following memory components of the system global area is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures?

  1. Stream pool

  2. Library cache

  3. SQL work area

  4. Instance creation

  5. pfile
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This memory component of the system global area is responsible for storing and reusing frequently used SQL statements, their execution plans and stored procedures.

Keep practicing — related questions