Oracle
1Z0-050 · Question #38
1Z0-050 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #38. 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
- ASnapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY
- BThe Oracle server dynamically generates the necessary statistics on tables as part of query
- COptimizer statistics are collected automatically
- DOnly timed operating system (OS) statistics and plan execution statistics are collected
- EThe snapshots for the Automatic Workload Repository (AWR) are not generated automatically
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 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.