找考题网-背景图
单项选择题

A.The optimizer statistics are collected automatically.……

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.

热门试题