试题详情
单项选择题 View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities：  SQL> SELECT substr（component， 0， 10） COMP， current_size CS，user_specified_size USFROM v$memory_dynamic_componentsWHERE 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 parallelquery operations have been performed.

  • C

  • 关注下方微信公众号，在线模考后查看

热门试题