Oracle
1Z0-117 · Question #21
1Z0-117 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
Question
You executed the following statements: Which two statements are true about the query execution?
Exhibit
Options
- AThe execution plan is generated and fetched from the library cache.
- BThe query executes and displays the execution plan and statistics.
- CThe query executes and inserts the execution plan in PLAN_TABLE.
- DThe query executes and execution plan is stored in the library cache and can be viewed using v$SQL_PLAN.
- EThe query will always use the plan displayed by the AUTOTRACE output.
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.