试题详情
单项选择题 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

  • 关注下方微信公众号，在线模考后查看

热门试题