Oracle Database Administration II — Question 75

Which two are true about the Oracle database methodology? (Choose two.)

Answer options

• A. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• B. Tuning activities should stop once the user is satisfied with performance.
• C. Tuning activities should stop once agreed service levels for performance have been met.
• D. The database instance memory should always be tuned before tuning any file systems.
• E. SQL statements should always be tuned before tuning any file systems.
• F. The alert log should be used to find the database and instance areas most in need of tuning.

Correct answer: A, E

Explanation

Option A is correct because the Oracle Database time model is specifically designed to help identify tuning needs within the database and instance. Option E is also correct as SQL statements should be optimized to ensure efficient performance before addressing file systems. Options B and C are incorrect because tuning should continue until both user satisfaction and service level agreements are met, not just user satisfaction alone. Options D and F are also incorrect as they suggest incorrect prioritization and methods for tuning.