Oracle
1Z0-054 · Question #213
1Z0-054 Question #213: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #213. The question stem and answer options stay visible for context.
Question
As a DBA configuring a new instance, you want to run a representative workload on the instance and examine the relevant statistics to see whether the cache is underconfigured or overconfigured.Given below is a list of the initialization parameters that would affect the statistics collection and advisories. 1. STATISTICS_LEVEL set to BASIC 2. STATISTICS_LEVEL set to TYPICAL 3. DB_CACHE_ADVICE set to ON 4. TIMED_STATISTICS set to TRUE Which of the above initialization parameters' values must be set explicitly to get the relevant statistics with minimal impact on the overall database performance?
Options
- Aonly 2
- B2 and 3
- C1, 3, and 4
- D2, 3, and 4
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.