Oracle
1Z0-117 · Question #97
1Z0-117 Question #97: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #97. The question stem and answer options stay visible for context.
Question
Examine Exhibit1 to view the query and its AUTOTRACE output. Which two statements are true about tracing?
Exhibit
Options
- AThe displayed plan will be stored in PLAN_TABLE.
- BSubsequent execution of this statement will use the displayed plan that is stored in v$SQL.
- CThe displayed plan may not necessarily be used by the optimizer.
- DThe query will not fetch any rows; it will display only the execution plan and statistics.
- EThe execution plan generated can be viewed from v$SQLAREA.
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.