Oracle
1Z0-117 · Question #109
1Z0-117 Question #109: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #109. The question stem and answer options stay visible for context.
Question
You are administering a database supporting an OLTP workload. A new module was added to one of the applications recently in which you notice that the SQL statements are highly resource intensive in terms of CPU, I/O and temporary space. You created a SQL Tuning Set (STS) containing all resource-intensive SQL statements. You want to analyze the entire workload captured in the STS. You plan to run the STS through the SQL Advisor. Which two recommendations can you get?
Options
- ACombing similar indexes into a single index
- BImplementing SQL profiles for the statements
- CSyntactic and semantic restructuring of SQL statements
- DDropping unused or invalid index.
- ECreating invisible indexes for the workload
- FCreating composite indexes for the workload
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.