Oracle
1Z0-083 · Question #149
1Z0-083 Question #149: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #149. The question stem and answer options stay visible for context.
Question
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)
Options
- AThe private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated
- BPGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
- CThe entire PGA is located in the System Global Area (SGA) when using shared servers.
- DSorts and Hash Joins use PGA memory.
- EThe private SQL area (UGA) is located in the System Global Area (SGA) when using shared
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.