Multiple choice technology databases

Which memory structures are shared? Choose two.

  1. Sort area

  2. Program Global Area

  3. Library cache

  4. Large pool
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Library Cache and Large Pool are shared memory structures in the SGA. Library Cache stores parsed SQL and PL/SQL, while Large Pool is for memory allocations like RMAN and parallel operations. PGA (Program Global Area) and Sort Area are private per process.

Keep practicing — related questions