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

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

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