READ Free Dumps For Oracle- 1z0-050
Question ID 1784 | Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.) |
Option A | A. It detects changes in SQL execution plans. |
Option B | B. It produces results that can be used to create the SQL plan baseline. |
Option C | C. The importance of SQL statements is based on the size of the objects accessed. |
Option D | D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs. |
Option E | E. It shows only the overall impact on workload and not the net SQL impact on workload. |
Correct Answer | A,B,D |
Question ID 1785 | Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.) |
Option A | A. Generate reports on data failure such as data file failures, |
Option B | B. You can package and upload diagnostic data to Oracle Support. |
Option C | C. You can track the Service Request (SR) and implement repairs. |
Option D | D. You can manually run health checks to gather diagnostic data for a problem. |
Correct Answer | B,C,D |