试题详情
单项选择题 in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting（）

A、Optimizer statistics are collected automatically.

B、Only timed operating system （OS） statistics and plan execution statistics are collected.

C、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.

D、Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.

E、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

  • C

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

热门试题