多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

View the Exhibit to examine the output produced by the following query at three different times since thedatabase 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_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 parallel queryoperations have been performed
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题