可学答题网 > 问答 > 1z0-043题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Your SPFILE contains t


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.
参考答案
参考解析:
分类:1z0-043题库
相关推荐

1、Your network contains 

Your network contains a single Active Directory domain named contoso.com.    An administrator&e...

2、Your network contains 

Your network contains an Active Directory domain controller named DC1. DDC1 runs Windows  Serve...

3、Your network contains 

Your network contains an Active Directory domain named contoso.com.  You  plan  to  d...

4、Your network contains 

Your network contains a server named Server1 that runs Windows Server 2003 Service Pack 2 ...

5、Your network contains 

Your network contains an Active Directory domain named contoso.com. The domain contains a print&ensp...

6、Your network contains 

Your network contains a single Active Directory domain. You have 100 servers that run Windows&e...