1Z0-040 : Oracle Database 10g: New Feature for Administrator

Retired. This product is no longer available.

The Oracle 10g DBA OCP certification is an industry recognized Oracle database administrator credential. The Oracle Database 10g: New Feature for Administrator exam is proof of a person's competence across a spectrum of skills including Database Server Configuration, Application Tuning, Space Management, Automatic Storage Management, and System Resource Management.
67 67
Oracle Database 10g: New Feature for Administrator

Here's what you will get

The Oracle Database 10g: New Features for Administratorsexam is required to upgrade an existing Oracle9i DBA OCP certification to the Oracle DBA OCP10g certification.

The 1Z0-040 exam is targeted at Database Administrators who are already certified as OCP DBA 9i and want to upgrade to their skills to the 10g database.

Pre-assessment Questions
Full Length Tests
Post-Assessment Questions
Exam FAQs
What is the exam registration fee? USD 195
Where do I take the exam? The 1Z0-040 exam is administered by Pearson VUE at the testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam? The exam consists of linear, fact based, multiple choices, and situational questions.
What are the pre-requisites of the exam?

Oracle has the following pre-requisites for the Oracle Database 10g: New Features for Administrators exam: * Oracle9i DBA OCP certification

If the candidate already holds an Oracle 9i DBA OCP certification, s/he can upgrade it to an Oracle 10g DBA OCP after passing this exam.Oracle and uCertify strongly recommend that the candidate complete the recommended training below, and/or have experience on Oracle Database 10g or Oracle Database 10g R2.

  • Oracle Database 10g: New Features for Administrators
  • Oracle Database 10g: New Features for Administrators Release 2
  • View additional 10g New Features Preparation.
How many questions are asked in the exam? The exam contains 60 questions.
What is the duration of the exam? 105 minutes
What is the passing score? 73%

(on a scale of 0-1000)

What is the exam's retake policy?

In the event that you fail your first attempt at passing the 1Z0-040 exam, Oracle's retake policy is:

  • You must wait 14 days before retaking a failed exam
  • Passed exams and Beta exams cannot be re-taken
  • Candidates may retake an online non-proctored 1Z0-007, 1Z0-051, 1Z0-200 and 1Z0-204 exam at any time.
What is the validity of the certification? Oracle 10g DBA OCP certification has no expiration. The certification holder is certified for life unless Oracle changes their policy. Click here for more information.
Where can I find more information about this exam? To know more about the 1Z0-040, click here.
What are the career opportunities after passing this exam?

An OCP DBA certified professional has several career opportunities open up to them, including:

  • Database Administrators
  • Web & App Server Administrators
  • Database Developers

Here's what you will learn

  • Describe installation new support features and installation performance enhancement.
  • Use SQL and PL/SQL to flush the Buffer Cache and...ing searching, sorting, matching, and replacing.
  • Understand the supported upgrade paths, pre-upgrade validation checks and start up the database.
  • Usages of some concepts involved in Oracle 10g: ... Enterprise Manager (EM) to view database usage.
  • Know about Data Pump.
  • Define external table properties and create external tables for data population.
  • Create a default permanent tablespace, transport...related error condition, and rename tablespaces.
  • Usages of some concepts involved in Oracle 10g: ...sor, SQL Tuning Advisor, and SQL Access Advisor.
  • Usages of some concepts involved in Oracle 10g: ...se of the performance pages of Database Control.
  • Monitor and maintain the AWR and manage the server generated alerts.
  • Explain and describe the automated task features and the advisory framework.
  • Know about ASM as a whole (setting up the initia...s, and use RMAN to migrate the database to ASM).
  • Create the SYSAUX tablepsace and relocate the SYSAUX occupants.
  • Copy files using the database server.
  • Usages of some concepts involved in Oracle 10g: ...lashback Transaction QueryUse of Flashback Table
  • Simplify file management for all recovery relate... opening the database with the RESETLOGS option.
  • Reduce the restore time by applying incremental ...nts by specifying limits in backup time windows.
  • Create faster incremental backups and save storage space through writing compressed backup sets.
  • Write MERGE statements with the new conditions and extension.
  • Usages of some concepts involved in Oracle 10g: ...efresh capabilities for materialized join views.
  • Create, maintain, and assign big file tablepsace, temporary tablespace groups to user.
  • Skip unusable indexes.
  • Create and maintain hash partitioned global indexes.
  • Specify storage characteristics for index partitions in the table partition DML commands.
  • Use the scheduler to create a job, a program schedule, and a window.
  • Automatically switch a session back to the original consumer group at the end of the top call.
  • Set idle time-outs for consumer groups.
  • Create mappings for the automatic assignments of sessions to consumer groups.
  • Apply a column-level VPD policy and statistical non-static policies.
  • Use fine-grained auditing and unified audit trails.
  • Share VPD policy functions.