OCP-1Z0-053-V12.02-640题

640.Examine the parameter setting in your database:

Which statement is correct about the database?

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and

SGA_TARGET are not set

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and

SGA_TARGET are set

C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET

and SGA_TARGET are set

D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global

Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

Answer: D

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12493791

 

因为Memory_target有设置有值，则启用AMM自动内存管理，使用动态内存管理时，SGA_TARGET和PGA_AGGREGATE_TARGET代表它们各自内存区域的最小设置，要让Oracle完全控制内存管理，这两个参数应该设置为0。

故只能选D。