1Z0-045 : Oracle Database 10g: New Features for Oracle8i OCPs

Retired. This product is no longer available.

The Oracle Database 10g DBA New Features for Oracle8i OCPs exam is required to upgrade an existing Oracle8i OCP certification to the Oracle Database 10g certification. The primary exam audience is DBAs who already holdan Oracle8i OCP certification. The exam has been validated against both Oracle Database 10g and Oracle Database 10g R2.
34 34
Oracle Database 10g: New Features for Oracle8i OCPs

Here's what you will get

The Oracle Database 10g DBA New Features for Oracle8i OCPs exam is an upgrade exam for those who hold an Oracle8i DBA OCP certification and want to upgrade to Oracle's DBA OCP 10g certification. Click here for more information.

It is an intermediate level exam primarily intended for DBAs involved withserver configuration, application tuning, space management, automatic storage management, system resource management and new features in Oracle 10g.

Test prep
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-045 exam is administered by Pearson VUE at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam? The exam consists of multiple choice questions.
What are the pre-requisites of the exam?

Oracle has the following pre-requisites for 1Z0-045 exam:

How many questions are asked in the exam? The exam contains 78 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 73%
What is the exam's retake policy?

In the event that you fail your first attempt at passing the 1Z0-045 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 exam at any time

Click here for more information.

What is the validity of the certification? The Oracle Database 10g DBA New Features for Oracle8i OCPs exam 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-045, click here.
What are the career opportunities after passing this exam?
  • Database Developers
  • Database Administrators
  • Database Experts
  • Database Managers
  • Database Analysts

Here's what you will learn

  • Describe the Flashback feature, resumable space allocation.
  • Describe LogMiner enhancements: DDL statement su... online dictionaryAbility to skip log corruption
  • Describe backup and recovery: RMAN manageability... such as block media recovery and trial recovery
  • Describe DRM enhancements that includes automati...the resource consumption other than CPU and DOP.
  • Describe online operations such as table redefinition and the use of SPFILE.
  • Describe segment management such as the Automatic Segment Space Management functionality.
  • Describe performance improvements such as cursor sharing enhancements.
  • Describe file management such as creating and managing OMF files.
  • Describe tablespace management such as creation and maintenance of UNDO tablespaces.
  • Describe memory management such as setting param...tomatic and dynamic sizing of SQL working areas.
  • Describe automatic management such as ADDM, auto...collection, and automatic undo retention tuning.
  • Describe system resource management: Automatic s...matic assignment of sessions to consumer groups.
  • Describe space management: Reduce space related ...nd SQL Access Advisors.Use sorted hash clusters.
  • Describe automatic storage management: Use ASM.S...M instances.Use RMAN to migrate database to ASM.
  • Describe backup and recovery enhancements: Simpl...up times by creating faster incremental backups.
  • Describe general storage enhancements: Create th...ase server.Using the redo log file size advisor.
  • Describe installation new features support and performance enhancements.
  • Describe the Unicode enhancements and the character set scanner.
  • Simplify instance configuration using a subset of initialization parameters.
  • Use of policy based database configuration framework.
  • Explain the privileged connection option.
  • View database usage statistics through EM Database Control.
  • Use of the new optimizer statistics and the performance pages of the EM Database Control utility.
  • Understand the supported upgrade paths to Oracle database 10g.
  • Use simplified upgrade process that automatically determines components to be upgraded.
  • Load and unload data: Transport tablespaces acro...tables and define the external table properties.
  • Describe manageability infrastructure: Monitor a...ed task feature.Describe the advisory framework.
  • Support for analytical applications: Write MERGE...ions to enhance SQL for analytical capabilities.
  • Simplify management tasks by using the scheduler.
  • Create a job, program, schedule, and window.
  • Reuse scheduler components for similar tasks.
  • View information about job executions and job instances.
  • Describe improved VLDB support: Create and maint...te and maintain hash partitioned global indexes.
  • Flashback any error: Configure and use flashback... point-in-time with the Flashback Table feature.
  • Provide greater flexibility by enabling resumable timeout at the instance level.
  • Use regular expression support in SQL and PL/SQL for string searching, matching, and replacing.
  • Use additional linguistic comparison and sorting methods in SQL.
  • Use SQL to flush the buffer cache.