READ Free Dumps For Oracle- 1z0-060
| Question ID 2159 |
|
| Option A | A. The optimizer used a dynamic plan for the query. |
| Option B | B. The optimizer chose different plans because automatic dynamic sampling was enabled. |
| Option C | C. The optimizer used re-optimization cardinality feedback for the query. |
| Option D | D. The optimizer chose different plan because extended statistics were created for the columns used. |
| Correct Answer | B |
| Question ID 2160 | Which three statements are true about adaptive SQL plan management? |
| Option A | A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans. |
| Option B | B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline. |
| Option C | C. It adds new, bettor plans automatically as fixed plans to the baseline. |
| Option D | D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans. |
| Option E | E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated. |
| Correct Answer | A,D,E |