Oracle 1z0-040 : Oracle Database 10g: New Features for Administrators Exam
The Oracle 1z0-040: Oracle Database 10g: New Features for Administrators exam is associated with certifications for Oracle9i DBA OCPs to Oracle Database 10g. It consists of 60 individual questions that must be answered within a 105-minute timeframe. Participants must score 73% or above to pass. However, the percentages are subject to change.
There are various exam topics, some, but not all, of which are listed below:
1. Installation- Exam participants should briefly describe installation of new features support and installation performance enhancements.
2. Server Configuration - Participants are asked to simplify instance configuration using a subset of initialization parameters, to use policy-based database configuration frame-work and to view database usage statistics through EM.
3. Automating Tasks with the Scheduler - Exam participants are asked to simplify management tasks by using the Scheduler. They are required to create a job, program, and schedule and window, to reuse scheduler components for similar tasks and to view information about job executions and job instances.
4. Improved VLDB Support - Exam participants are asked to create and maintain bigfile tablespaces, to create temporary tablespace groups and to assign temporary tablespace groups to users. They should have the ability to skip indexes that are not useable and specify storage characteristics for index partitions in the table partition DML commands.