欢迎来到牛牛题库网 牛牛题库官网
logo
全部科目 > Oracle认证考试 > 1z0-043

单项选择题

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that 
coordinates the sizing of the memory components?()  

A. MMAN
B. PMON
C. MMON
D. MMNL

点击查看答案

相关考题

多项选择题

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.

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题