READ Free Dumps For Oracle- 1z0-050
| Question ID 6007 | Which two statements are true regarding the SQL Repair Advisor? (Choose two.) |
| Option A | The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements. |
| Option B | The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash. |
| Option C | The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement. |
| Option D | The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR. |
| Correct Answer | B,D |
| Question ID 6008 | Which setting enables the baselines by default in Oracle Database 11g? |
| Option A | setting the STATISTICS_LEVEL parameter to TYPICAL |
| Option B | adding filters to the Automatic Database Diagnostic Monitor (ADDM) |
| Option C | enabling Automated Maintenance Task using Oracle Enterprise Manager |
| Option D | setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE |
| Correct Answer | A |