READ Free Dumps For Oracle- 1z0-050
| Question ID 1859 | Which two statements are true regarding the SQL Repair Advisor? (Choose two.) |
| Option A | A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements. |
| Option B | B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash. |
| Option C | C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement. |
| Option D | 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 1860 | Which setting enables the baselines by default in Oracle Database 11g? |
| Option A | A. setting the STATISTICS_LEVEL parameter to TYPICAL |
| Option B | B. adding filters to the Automatic Database Diagnostic Monitor (ADDM) |
| Option C | C. enabling Automated Maintenance Task using Oracle Enterprise Manager |
| Option D | D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE |
| Correct Answer | A |