（55）View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:

SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US

FROM v$memory_dynamic_components WHERE current_size != 0;

What do you infer from this?

A. The database instance is running with manual PGA management.

B.The database instance is running with manual shared memory management.

C.The database instance has the MEMORY_TARGET value set to a nonzero value.

D.All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

答案：（C）

解析：

A（X）. 因为PGA Target的user_specified_size = 0，所以为自动PGA管理

B（X）. 因为SGA Target的user_specified_size = 0，所以为自动共享内存管理

D（X）. 无法判断出是运行在Dedicated Server还是Shared Server

ITPub博客

Oracle 11G OCP 1Z0-052 55

最新文章