READ Free Dumps For Oracle- 1z0-117
| Question ID 2542 | An application user complains about statement execution taking longer than usual. You find that the query uses a bind variable in the WHERE clause as follows: |
| Option A | A. Use the DBMS_XPLAN.DISPLAY function to view the execution plan. |
| Option B | B. Identify the SQL_ID for the statementsand use DBMS_XPLAN.DISPLAY_CURSOR for that SQL_ID to view the execution plan. |
| Option C | C. Identify the SQL_ID for the statement and fetch the execution plan PLAN_TABLE. |
| Option D | D. View the execution plan for the statement from V$SQL_PLAN. |
| Option E | E. Execute the statement with different bind values and set AUTOTRACE enabled for session. |
| Correct Answer | B,D |
| Question ID 2543 | Which statement is true about an SQL plan baselines that are fixed? |
| Option A | A. New plans are added automatically by the optimizer to the baseline and are automatically evolved. |
| Option B | B. New, better plans are added automatically as a fixed plan baseline. |
| Option C | C. New plan can be manually loaded to the baseline from the cursor cache or a SQL tuning set. |
| Option D | D. New plans can be added as fixed plans to the baseline by using the SQL Tuning Advisor to generate a SQL profile and by accepting the SQL profile. |
| Correct Answer | D |