55.View the Exhibit to examine the output produced by the following query at three different times s

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:
SQL> 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.
MM is set to 100 MB.
答案：C
解析：从图中可以看出sga_target和pga_target三次都不一样，说明启用了amm
因此选择C，具体内容可以参考53题
V$MEMORY_DYNAMIC_COMPONENTS：动态查询各个内存组件的大小