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)
A.
The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B.
The Oracle database automatically controls the amount of PGA memory allotted to SQL
work areas.
C.
Setting the value of the SGA_TARGET initialization parameter to 0 will disable the
automatic PGA memory management.
D.
The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic
PGA memory management mode.