Skills required for Oracle test 1z0-040

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

Skills required for Oracle test 1z0-040

Rating:

Oracle has specified 1z0-040 (Oracle Database 10g: New features for Administrators) as an upgrade certification test, which helps one to upgrade from an Oracle 9i Certified Professional to an Oracle 10g Certified Professional (OCP). Oracle specifies 80 objectives under 17 chapters. Before taking the test, an individual should possess a sound knowledge of the following concepts, tools, and techniques:

1. Installing Oracle 10g.
2. Knowing about new installation features.
3. Using policy-based database configuration framework.
4. Using EM for various purposes such as viewing database usage statistics, viewing database performance statistics, etc.
5. Knowing the Data Pump utility.
6. Knowing about automatic space management concepts such as advisors, segment shrink functionality, Automatic Database Diagnostic monitoring (ADDM), RMAN to migrate a database to ASM, initialization parameter files, SQL statements, etc.
7. Managing the AWR and server-generated alerts.
8. Performing system resource management.
9. Automating tasks with the scheduler.
10. Knowing about the improved VLDB supports.
11. Performing database backup and recovery with enhanced features.
12. Flashing back a database.
13. Knowing about the general storage enhancements.
14. Maintaining the software.
15. Implementing the database security.

Rating: