Oracle
1Z0-043 · Question #142
1Z0-043 Question #142: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #142. The question stem and answer options stay visible for context.
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
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 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.