Oracle
1Z0-054 · Question #192
1Z0-054 Question #192: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #192. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the result of Automatic SQL Tuning for a period. None of the recommended SQL profiles are implemented. What would you do to allow the Automatic SQL Tuning implement the SQL profiles automatically?
Exhibit
Options
- ASet the OPTIMIZER_MODE parameter to ALL_ROWS for the database instance.
- BSet the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
- CSet the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE for the database
- DUse the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set
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.