Oracle
1Z0-054 · Question #193
1Z0-054 Question #193: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #193. The question stem and answer options stay visible for context.
Question
You used SQL Tuning Advisor for a long-running SQL statement that suggested a SQL profile which can be used by the query subsequently for better execution plan. View the Exhibit. But you want certain user sessions not to use this SQL profile for their queries. How would you implement this?
Exhibit
Options
- AAlter the SQL profile to change the category of the SQL profile.
- BSet the OPTIMIZER_USE_PENDING_STATISTICS to TRUE the desired sessions.
- CUse database resource manager to prevent the use of the SQL profile by these user sessions.
- DUse database resource manager to preUse the resource management feature in profiles of these
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.