READ Free Dumps For Oracle- 1z0-117
| Question ID 2619 | Which two statements are true about index full scans? |
| Option A | A. An index fast full scan multi block I/O to read the index structure in its entirely. |
| Option B | B. Index nodes are not retrieved in the index order, and there fore the nodes are not in sequence. |
| Option C | C. An index fast full scan reads the index block by block. |
| Option D | D. An index fast full scan reads the whole index from the lowest value to the higher value. |
| Correct Answer | A,B |
| Question ID 2620 | An application supplied by a new vendor is being deployed and the SQL statements have plan baselines provided by the supplier. The plans have been loaded from a SQL tuning set. You require the optimizer to use these baselines, but allow better plans to used, should any be created. |
| Option A | A. Set the OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter to TRUE. |
| Option B | B. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES initialization parameter to TRUE. |
| Option C | C. Use the DBMS_SPM.ALTER_SQL_PLAN_BASELINE function to fix the plans. |
| Option D | D. Use the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function to fix the new plans. |
| Option E | E. Use the DBMS_SPM.ALTER_SQL_BASELINE function to accept new plans. |
| Correct Answer | A,B |