READ Free Dumps For Oracle- 1z0-117
| Question ID 2554 | You executed the following statements: |
| Option A | A. The execution plan is generated and fetched from the library cache. |
| Option B | B. The query executes and displays the execution plan and statistics. |
| Option C | C. The query executes and inserts the execution plan in PLAN_TABLE. |
| Option D | D. The query executes and execution plan is stored in the library cache and can be viewed using v$SQL_PLAN. |
| Option E | E. The query will always use the plan displayed by the AUTOTRACE output. |
| Correct Answer | B,D |
| Question ID 2555 | How can you reduce fragmentation of an index without affecting the current transactions that are using the index? |
| Option A | A. Use the ANALYZE INDEX . . . command |
| Option B | B. Use the ALTER INDEX . . . VALIDATE STRUCTURE command |
| Option C | C. Us the ALTER INDEX . . . REBUILD ONLINE command |
| Option D | D. Use the ALTER INDEX . . . DEALLOCATE UNUSED command |
| Correct Answer | C |