Oracle Database Administration II — Question 106

Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

Answer options

• A. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
• B. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
• C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
• D. Sorts and Hash Joins use PGA memory.
• E. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

Correct answer: A, B

Explanation

The correct answers are A and B because A correctly states that the private SQL area (UGA) is stored in the SGA for dedicated servers, and B correctly highlights that PGA_AGGREGATE_LIMIT sets a hard cap on the PGA size per session. Options C and E are incorrect as they misrepresent the location of UGA in relation to shared servers, while option D, although true regarding Sorts and Hash Joins using PGA memory, is not one of the two correct answers being asked for.