多项选择题
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.
相关考题
-
单项选择题
Yourdatabaseisusingsharedserverconfiguration.WhichoptionalmemorystructurewouldyouconfiguretostoretheUserGlobalArea（UGA）informationandimprovethesharedpoolperformance？（）
A.large pool
B.streams pool
C.keep buffer cache
D.recycle buffer cache -
单项选择题
In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
A.The STATISTICS_LEVEL initialization parameter is set to BASIC
B.The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
C.The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
D.The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
E.The SHARED_POOL_SIZE initialization parameter is set to a nonzero value. -
单项选择题
InyourproductiondatabaseyouwanttouseanAutomaticStorageManagement（ASM）instancetomanagethedatabasefiles.Whichoptionwouldyouusetomigratethedatabasefilesfromanon-ASMinstancetoanASMinstance？（）
A.Oracle Migration Assistant
B.Recovery Manager （RMAN）
C.Oracle Data Pump Export and Import
D.conventional Oracle Export and Import
E.operating system utilities to copy the files to the ASM instance
