READ Free Dumps For Oracle- 1z0-050
| Question ID 6043 | While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.) |
| Option A | The plan baselines can be evolved over time to produce better performance |
| Option B | The newly generated plans are directly placed into the SQL plan baseline without being verified. |
| Option C | The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration. |
| Option D | The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported. |
| Correct Answer | A,C |
| Question ID 6044 | You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window? |
| Option A | The collection level for the AWR should be set to BASIC. |
| Option B | The moving window size must be less than Undo Retention. |
| Option C | The moving window size should be greater than the Automatic Workload Repository (AWR) retention period. |
| Option D | The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period. |
| Correct Answer | D |