What is the effect of setting the STATISTICS_LEVEL initia lization parameter to BASIC?
A. Optimizer statistics are collected automatically
B. Only timed operating system (OS) statistics and plan execution statistics are collected
C. Automatic Workload Repository (AWR) snapshots are not generated automatically.
D. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.
|
Download Printable PDF. VALID exam to help you PASS. |
 |