READ Free Dumps For Oracle- 1z0-050
| Question ID 6019 | Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.) |
| Option A | It does not allow you to change the moving window size, |
| Option B | Adaptive threshold functionalities use it by default to compute statistics. |
| Option C | It is created by default with the window size being equal to the AWR retention time. |
| Option D | It is created when the first snapshot is collected by the Automatic Workload Repository (AWR). |
| Option E |
|
| Correct Answer | B,C |
| Question ID 6020 | The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework? |
| Option A | statistics recommendations |
| Option B | SQL profile recommendations |
| Option C | index-related recommendations |
| Option D | restructuring of SQL recommendations |
| Correct Answer | B |