Oracle
1Z0-043 · Question #142
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario?…
The correct answer is B. The Oracle database automatically controls the amount of PGA memory allotted to SQL D. The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA. See the full explanation below for the reasoning.
Question
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? (Choose two)
Options
- AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
- BThe Oracle database automatically controls the amount of PGA memory allotted to SQL
- CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic
- DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA
How the community answered
(29 responses)- A7% (2)
- B76% (22)
- C17% (5)
Community Discussion
No community discussion yet for this question.