Oracle's 1Z0-043

Oracle Database 10g: Administration II

The Oracle Database 10g: Administration II exam is a mandatory part of Oracle's 10g DBA OCP certification. This exam takes DBAs beyond a basic understanding of their Oracle environment and focuses on more advanced skills required to effectively configure, administer, monitor and tune Oracle 10g databases within a large-scale enterprise. uCertify’s guaranteed certification course for 1Z0-043 exam is comprehensive and helps you earn your certification and gain knowledge. Here’s what to expect from your uCertify course:

• 100% Exam Coverage • Interactive E-Book • Pre-Assessment • 244 Practice Questions with Full Explanations • 206 Interactive Quizzes • Test History and Performance Review and Powerful Analytics • Study Planner • Continuously Updated



The Oracle Database 10g: Administration II exam is part of Oracle's DBA OCP 10g certification. It is a required piece to the certification. There are four steps required forthe Oracle Database 10g Administrator Certified Professional certification. You should have Oracle Database 10g Administrator Certified Associate certification before taking this certification, then you need to complete one of the approved advanced courses as mentioned by Oracle , pass 1Z0-043 exam, and the last step is to complete the Course Submission Form.

These steps can be completed in any order but the stipulated courses and certification exams must be passed before completing Oracle's course Submission Form.

Skills Measured

  • Database Recovery
  • Database Resource Management
  • Administration of VLDBs
  • Advanced Database Security
  • Index rebuilding

Related Certifications

1Z0-043 Course Duration

This is a self-paced, independent study program, so there are no minimum or maximum restrictions placed by uCertify. The amount of time you will take depends on your existing knowledge of the area and related experience, as well as your availability. We recommend at least 2 weeks if you have met all the pre-requisites and have a reasonable amount of database administration work experience.

Related Exams

Authored by Industry Experts

uCertify uses content from the finest publishers and only the IT industry's finest instructors. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can study at your own pace. This creates a personal learning experience and gives you all the benefits of hands-on training with the flexibility of doing it around your schedule 24/7.

Exercises, Quizzes & Flashcards

uCertify's exercises, quizzes and flashcards prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcards and exercises after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.

Practice Test Sets

uCertify courses also include full length practice test sets designed to test your knowledge under real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Exam Simulators

Online labs to supplement your training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

State of the Art Educator Tools

uCertify knows the importance of instructors and provide tools to help them do their job effectively. Instructors are able to clone and customize course, do ability grouping, create sections, design grade scale and grade formula, create and schedule assignments. Educators can also move a student from self-paced to mentor-guided to instructor-led mode in three clicks.

Award Winning Learning Platform (LMS)

uCertify has developed an award winning, highly interactive yet simple to use platform. uCertify understands that it is critical to help student focus on learning the subject and not learning the LMS. uCertify helps student retain and recall the knowledge by teaching students using interactive exercises. Features such as actionable analytics and study planner help in keeping students focused.


1Z0-043 Course/Exam Objectives

  • Lesson 1: Using Globalization Support Objectives
    • Customize language-dependent behavior for the database and individual sessions.
    • Specify different linguistic sorts for queries.
    • Use datatime datatypes
    • Query data using case insensitive and accent insensitive searches
    • Obtain Globalization support configuration information
  • Lesson 2: Configuring Recovery Manager
    • Configure database parameters that affect RMAN operations
    • Change RMAN default settings with CONFIGURE
    • Manage RMAN s persistent settings
    • Start RMAN utility and allocate channels
  • Lesson 3: Recovering from User Errors
    • Recover a dropped table using Flashback technology
    • Perform Flashback table operation
    • Manage the recycle bin
    • Recover from user errors using Flashback versions query
    • Perform transaction level recovery using Flashback Transaction query
  • Lesson 4: Dealing with Database Corruption
    • Define block corruption and list its causes and symptoms
    • Detect database corruptions using the following utilities: ANALYZE DBVERIFY
    • Detect database corruptions using the dbms_repair package
    • Implement the DB_BLOCK_CHECKING parameter to detect corruptions
    • Repair corruptions using RMAN
  • Lesson 5: Automatic Database Management
    • Use the Database Advisors to gather information about your database
    • Use the SQL Tuning Advisor to improve database performance
    • Use automatic undo retention tuning
  • Lesson 6: Using Recovery Manager
    • Use the RMAN BACKUP command to create backup sets and image copies
    • Enable block change tracking
    • Manage the backups and image copies taken with RMAN with the LIST and REPORT commands.
  • Lesson 7: Recovering from Non-Critical Losses
    • Recover temporary tablespaces
    • Recover a redo log group member
    • Recover index tablespaces
    • Recover read-only tablespaces
    • Recreate the password file
  • Lesson 8: Monitoring and Managing Storage
    • Tune redo writing and archiving operations
    • Issue statements that can be suspended upon encountering space condition errors
    • Reduce space-related error conditions by proactively managing tablespace usage
    • Reclaim wasted space from tables and indexes using the segment shrink functionality.
    • Estimate the size of new table and indexes
    • Use different storage options to improve the performance of queries
    • Rebuild indexes online
  • Lesson 9: Automatic Storage Management
    • Set up initialization parameter files for ASM and database instances
    • Execute SQL commands with ASM file names
    • Start up and shut down ASM instances
    • Administer ASM disk groups
    • Use RMAN to migrate your database to ASM
  • Lesson 10: Monitoring and Managing Memory
    • Implement Automatic Shared Memory Management
    • Manually configure SGA parameters for various memory components in the SGA
    • Use Automatic PGA Memory Management
  • Lesson 11: Database Recovery
    • Recover the control file
    • Explain reasons for incomplete recovery
    • Perform incomplete recovery using EM
    • Perform incomplete recovery using RMAN
    • Perform incomplete recovery using SQL
    • Perform database recovery following a RESETLOGS operation
  • Lesson 12: Flashback Database
    • Determine which flashback technology to use for each recovery situation
    • Configure and use Flashback Database
    • Monitor the Flashback Database
    • Use the Enterprise Manager Recovery Wizard to flashback database
    • Manage (or maintain) the Flash Recovery Area
  • Lesson 13: Managing Resources
    • Configure the Resource Manager
    • Assign users to Resource Manager groups
    • Create resource plans within groups
    • Specify directives for allocating resources to consumer groups
  • Lesson 14: Automating Tasks with the Scheduler
    • 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

Career Prospects

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

  • Database Administrators
  • Pre-Sales Consultants
  • Support Engineers
  • Technical Consultants


1Z0-043 Exam FAQs

What is the exam registration fee?
USD 195

Pricing and taxes may vary from country to country.

Where do I take the exam?
The 1Z0-043 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 choice, and situational questions.
What are the pre-requisites of the exam?

Oracle requires the following training and certifications to earn the Oracle Database 10g Administrator Certified Professional certification, which is the last technical requirement. Two other courses/certifications that must be completed before the Oracle Database 10g Administrator Certified Professional title can be earned are:

How many questions are asked in the exam?
The exam contains 88 questions.
What is the duration of the exam?
90 minutes
What is the passing score?

(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-043 exam, Oracle's retake policy is:

  • You must wait at least 14 days before retaking a failed proctored exam
  • Passed exams and Beta exams cannot be re-taken
  • Candidates may retake an online non-proctored exam (1Z0-007, 1Z0-051, 1Z0-200 and 1Z0-204) at any time
What is the validity of the certification?
The Oracle Database 10g Administrator Certified Professional 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-043 exam, click here.

At a Glance

1Z0-043 Course Includes Free Buy
Lessons 1 14
Pre-Assessment Yes Yes
Practice Tests 0 2
Total Questions 30 244
Interactive Quizzes 15 206
Final Test No Yes

Copyright © 2014 uCertify / All rights reserved.