Oracle
1Z0-052 · Question #153
1Z0-052 Question #153: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.
Question
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?
Options
- AOptimizer statistics are collected automatically.
- BOnly timed operating system (OS) statistics and plan execution statistics are collected.
- CThe snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
- DSnapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
- EThe Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.