Your SPFILE contains the following parameter settings：  
SGA_TARGET = 8G  
DB_CACHE_SIZE = 4G  
SHARED_POOL_SIZE = 2G  
LARGE_POOL_SIZE = 512M  
JAVA_POOL_SIZE = 512M  
LOG_BUFFER = 100M  
SGA_MAX_SIZE = 10G  
You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement：  
SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH；  
What is the result of this statement？（）  

单项选择题You create an Oracle 10g database and configure the SPFILE as follows：   SGA_TARGET=2G   DB_CACHE_SIZE=512M  LOG_BUFFER=50M   DB_KEEP_CACHE_SIZE=128M   You modify the SGA_TARGET initialization parameter using the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；   Which entity does this statement affect？（）

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？（）

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.