Exam 1z0-083 All QuestionsBrowse all questions from this exam
Go to Exam
Question 127

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

    Correct Answer: D, E

    Sorts and Hash Joins use PGA memory because these operations typically require memory that pertains to a specific session's work, therefore involving the Program Global Area. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers because, in shared server mode, the user global area must be available to any server process servicing the client session. This ensures that the information persists and is accessible across multiple server processes.

Discussion
RinDOptions: DE

DE correct

Kuraudio

E explanation: "The UGA must be available to a database session for the life of the session. For this reason, the UGA cannot be stored in the PGA when using a shared server connection because the PGA is specific to a single process. Therefore, the UGA is stored in the SGA when using shared server connections, enabling any shared server process access to it. When using a dedicated server connection, the UGA is stored in the PGA. "

ObserverPLOptions: DE

Agree, D and E

nobody347Options: DE

D and E 100%

ABAJOptions: DE

DE are correct answer.

dunhillOptions: DE

I think DE

_gio_Options: DE

DE excluding wrong answers, but only a specific part of Private SQL Area is located in SGA when shared server is enables

ScottLOptions: DE

DE correct. https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-0788EAEE-0E93-497B-9ACA-401EC0F7BCA1

vkraOptions: DE

DE https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-0788EAEE-0E93-497B-9ACA-401EC0F7BCA1

hilaireOptions: DE

D E sure

RogazanOptions: DE

I agree with DE. (https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-913335DF-050A-479A-A653-68A064DCCA41)