单项选择题
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？（）
A. 940M
B. 990M
C. 690M
D. 1000M
相关考题
-
多项选择题
TheAutomaticSharedMemoryManagementfeatureisenabledforthePRODdatabase.Currently，alotofinsertactivityistakingplaceinthedatabase，andthememorystructuresareallocatedaccordingtothedatabaseworkload.Astheworkloadreduces，youdecidetoperformbatchjobsinthedatabase.WhichofthefollowinginitializationparametersareNOTautomaticallyresizedaccordingtothenewworkloadandcontinuetoremainunchanged？（）
A. LOG_BUFFER
B. DB_CACHE_SIZE
C. JAVA_POOL_SIZE
D. LARGE_POOL_SIZE
E. SHARED_POOL_SIZE
F. STREAMS_POOL_SIZE -
单项选择题
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？（）
A. The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
B. The total numbers of alerts that you receive every day will be reduced.
C. The total number of alerts that you receive every day will be increased.
D. No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used. -
单项选择题
AjuniorlevelDatabaseAdministratorerroneouslydeletedthedatabasealertlogwhileuserswereaccessingthedatabase.Whichactionshouldyoutaketorecoverthealertlog？（）
A. Do nothing.
B. Restart the database.
C. Perform recovery on the database.
D. Restore the alert log from the last backup.
