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

Oracle认证考试

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

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?()  

  • A、 The database crashes.
  • B、 The large pool releases 512M of memory.
  • C、 The large pool retains 1G of allocated memory.
  • D、 The large pool increases to 1,512M of memory.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题