Oracle
1Z0-117 · Question #106
1Z0-117 Question #106: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #106. The question stem and answer options stay visible for context.
Question
You created a SQL Tuning Set (STS) containing resource-intensive SQL statements. You plan to run the SQL Tuning Advisor. Which two types of recommendations can be provided by the SQL Tuning Advisor?
Options
- ASemantic restructuring for each SQL statement
- BGathering missing or stale statistics at the schema level for the entire workload
- CCreating a materialized view to benefit from query rewrite for the entire workload
- DGathering missing or stale statistics for objects used by the statements.
- ECreating a partition table to benefit from partition pruning for each statement
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 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.