单项选择题

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?()