1Z0-083 practice question 11 of 35
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)
Full set: 286 questionsThe Oracle Optimizer relies on statistics to estimate the cost of execution plans. The BTree height (BLEVEL) is a crucial index statistic used to calculate the cost of traversing an index to find the first leaf block. The Statistics Advisor is a component of the SQL Tuning Advisor that analyzes how statistics are gathered. It can diagnose issues and provide recommendations, including generating scripts to implement improved statistics collection methods. These features are central to maintaining optimal query performance.
A. The number of table rows (NUMROWS) is a table statistic, not an index statistic. While used to estimate cardinality for the overall operation, BLEVEL is more direct to the index access cost.
D. Statistics can become stale or may not accurately represent skewed data, potentially leading to suboptimal plans. They do not "always" yield the best result.
E. The Statistics Advisor generates recommendations; it may generate scripts for some actions, but it does not automatically generate executable actions for all possible recommendations.
1. Oracle Database SQL Tuning Guide, 19c, Chapter 14, "Optimizer Statistics Concepts". (Discusses index statistics like BLEVEL and their use in cost calculation).
2. Oracle Database SQL Tuning Guide, 19c, Section 15.3.1, "Cost-Based Optimizer". (Explains how costs are calculated using statistics).
3. Oracle Database SQL Tuning Guide, 19c, Chapter 6, "Using the Automatic SQL Tuning Advisor". (Describes the role and capabilities of the Statistics Advisor).
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
