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？（）A. The SGA_TARGET initialization parameter cannot be set to a value less than 1GB. The SGA_TARGET initialization parameter cannot be set to a value greater than 1GC. The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGAD. The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.E. No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.F. The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.

多项选择题

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

A. The SGA_TARGET initialization parameter cannot be set to a value less than 1G
B. The SGA_TARGET initialization parameter cannot be set to a value greater than 1G
C. The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA
D. The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.
E. No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.
F. The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.

相关考题

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

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

1z0-043