In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
A:The optimizer statistics are collected automatically.
B:Only the timed operating system (OS) statistics and plan execution statistics are collected.
C:The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D:The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
E:Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
出自:Oracle认证