READ Free Dumps For Oracle- 1z0-050
Question ID 6003 | Which three statements correctly describe the features of the I/O calibration process? (Choose three.) |
Option A | Only one I/O calibration process can run at a time |
Option B | It automates the resource allocation for the Automated Maintenance Tasks. |
Option C | It improves the performance of the performance-critical sessions while running. |
Option D | It can be used to estimate the maximum number of l/Os and maximum latency time for the system. |
Option E | The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE. |
Correct Answer | A,D,E |
Question ID 6004 | Which two statements about the SQL Management Base (SMB) are true? (Choose two.) |
Option A | It contains only SQL profiles generated by SQL Tuning Advisor. |
Option B | It stores plans generated by the optimizer using a stored outline. |
Option C | It is part of the data dictionary and stored in the SYSAUXtablespace. |
Option D | It is part of the data dictionary and stored in the SYSTEM tablespace. |
Option E | It contains the statement log, the plan history, plan baselines, and SQL profiles. |
Correct Answer | C,E |