1Z0-117 · Question #11
1Z0-117 Question #11: Real Exam Question with Answer & Explanation
The correct answer is B. Identify the SQL_ID for the statementsand use DBMS_XPLAN.DISPLAY_CURSOR for that SQL_ID to D. View the execution plan for the statement from V$SQL_PLAN.. D: V$SQL_PLAN contains the execution plan information for each child cursor loaded in the B: The DBMS_XPLAN package supplies five table functions: DISPLAY_SQL_PLAN_BASELINE - to display one or more execution plans for the SQL statement identified by SQL handle DISPLAY - to format
Question
Options
- AUse the DBMS_XPLAN.DISPLAY function to view the execution plan.
- BIdentify the SQL_ID for the statementsand use DBMS_XPLAN.DISPLAY_CURSOR for that SQL_ID to
- CIdentify the SQL_ID for the statement and fetch the execution plan PLAN_TABLE.
- DView the execution plan for the statement from V$SQL_PLAN.
- EExecute the statement with different bind values and set AUTOTRACE enabled for session.
Explanation
D: V$SQL_PLAN contains the execution plan information for each child cursor loaded in the B: The DBMS_XPLAN package supplies five table functions: DISPLAY_SQL_PLAN_BASELINE - to display one or more execution plans for the SQL statement identified by SQL handle DISPLAY - to format and display the contents of a plan table. DISPLAY_AWR - to format and display the contents of the execution plan of a stored SQL statement in the AWR. DISPLAY_CURSOR - to format and display the contents of the execution plan of any loaded cursor. DISPLAY_SQLSET - to format and display the contents of the execution plan of statements stored in a SQL tuning set.
Community Discussion
No community discussion yet for this question.