多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:C,E
答案解析:
进入题库查看解析

微信扫一扫手机做题