Oracle
1Z0-417 · Question #4
What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?
The correct answer is B. Oracle Databases are constantly changing; more users, data added and deleted, varying SQL at D. Inefficient "Bad" application SQL can be detected by Diagnostics Pack and then optimized utilizing. See the full explanation below for the reasoning.
Question
What are two reasons for which the Diagnostics and Tuning packs are essential to ongoing maintenance of an Oracle Database?
Options
- AWith Diagnostics and Tuning Packs installed, an Oracle database recovers easily from a crash or
- BOracle Databases are constantly changing; more users, data added and deleted, varying SQL at
- CDiagnostics and Tuning Packs are needed to keep Oracle Database table and index statistics
- DInefficient "Bad" application SQL can be detected by Diagnostics Pack and then optimized utilizing
- EDiagnostics and Tuning packs are a prerequisite for a customer to license Oracle Database
How the community answered
(40 responses)- A13% (5)
- B80% (32)
- C5% (2)
- E3% (1)
Community Discussion
No community discussion yet for this question.