移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

多选题

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

发布日期:2020-04-10

You set the value of the SGA_TARGET initialization...
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.

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~