多项选择题 You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement：   SQL> SELECT name， value， isdefault  2 FROM v$parameter   3 WHERE name LIKE ’%size%’；   The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE，  LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value.  What does this imply？（）

单项选择题 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？（）