Oracle 26ai · SQL Tuning · Module 8

Module 8

Cost-Based Optimization Quiz

Four questions, one point each. Checkbox questions require exactly the correct choices, with no partial credit. Duplicate or invalid choices do not earn credit.

1. Which statements describe modern cost-based planning?

Select all correct answers.

2. Which tool should you use to gather optimizer statistics for a selected training table?

Select one answer.

3. Which statements about histograms are correct?

Select all correct answers.

4. A query is slower and its plan contains a full table scan. What should you do first?

Select one answer.