Which two statements are correct in this scenario?

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)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *