单项选择题
A. only the auto-tuned memory components
B. only the memory components that are not auto-tuned
C. both the auto-tuned memory components and the non-auto-tuned memory components
D. neither the auto-tuned memory components nor the non-auto-tuned memory components
单项选择题 The SPFILE for your database contains the following parameter settings: SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto-tuned memory components?()
多项选择题 TheAutomaticSharedMemoryManagementfeatureisenabledforthePRODdatabase.Currently,alotofinsertactivityistakingplaceinthedatabase,andthememorystructuresareallocatedaccordingtothedatabaseworkload.Astheworkloadreduces,youdecidetoperformbatchjobsinthedatabase.WhichofthefollowinginitializationparametersareNOTautomaticallyresizedaccordingtothenewworkloadandcontinuetoremainunchanged?()
单项选择题 The warning level threshold value for a tablespace, DATA1, is set to 60% and the critical level threshold value is set to 80%. The tablespace, DATA1, is infrequently used and is not a part of the production environment. You issued the following command: SQL> EXECUTE DBMS_SERVER_ALERT.SET_THRESHOLD (dbms_server_alert.tablespace_pct_full, dbms_server_alert.operator_ge,80, dbms_server_alert.operator_ge,90, 1,1,NULL, dbms_server_alert.object_type_tablespace,’DATA’); What will be the result of the command?()