试题详情
多项选择题 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?()

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.

  • B,D
  • 关注下方微信公众号,在线模考后查看

热门试题