Oracle Exam 1Z0-083 Topic 7 Question 12 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 12
Topic #: 7

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

instance? (Choose two.)

AThe private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

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 servers.

Show Suggested Answer

Suggested Answer: A, B

by Sylvia at May 05, 2022, 05:07 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!