Oracle Corporation

Oracle Database 11g Administrator Certified Professional


Credential: Oracle Database 11g Administrator Certified Professional  In-Demand resource  GI Bill resource  Army eLearning resource CA Eligible
Credentialing Agency: Oracle Corporation

Renewal Period: Not Renewable

Oracle Corporation, Oracle Database 11g Administrator Certified Professional (OCP) is an intermediate credential that equips individuals to install, maintain, troubleshoot, and fine-tune all aspects of an Oracle database. Oracle certified database administrators keep an Oracle database environment running at maximum efficiency. The OCP is the next step up in a database administrator's path that requires the passing of one or more exams as well as having to attend an instructor led course (or an online one). Candidates must have already passed the OCA exams to register for the OCP. There are no education or experience prerequisites.

More information can be found on the certifying agency's website.

Oracle Database 11g Administrator Certified Professional

MINIMUM REQUIREMENTS

Attainability:    medium

Eligibility Requirements (View Details)

  • Credential Prerequisite: Oracle Database 11g Administrator Certified Associate
  • Experience
  • Education
  • Training
  • Membership
  • Other
  • Fee

Note: This credential may have multiple options for a Service member to meet eligibility requirements. Requirements listed here are based on the minimum degree required. To view other options, see the Eligibility tab.

Exam Requirements (View Details)

  • Exam
  • Written Exam
  • Oral Exam
  • Practical Exam
  • Performance Assessment

Exam Administration (View Details)

  • In-person exam
  • Remote proctored on-line exam
  • Third-party test vendor

RECERTIFICATION SUMMARY

Renewal Period: Not Renewable

  • Continuing Education
  • Exam
  • Continuing Education OR Exam
  • Fee
  • Other

AGENCY CONTACT INFORMATION

Oracle Corporation

500 Oracle Parkway
Redwood Shores, CA  94065

Phone: (650) 506-7000

Contact Page

Candidate must have earned the Oracle Database 11g Administrator Certified Associate credential.

Candidate must complete one of the approved instructor-led online or in-class courses. A list of eligible courses to complete this requirement can be found here on the Oracle website.

Written Exam 1Z0-083

  • Creating CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
    • Configure and create a CDB
    • Create a new PDB from the CDB seed
    • Explore the structure of PDBs
  • Backup and Duplicate - Oracle Database: Managing Multitenant Architecture Ed 1
    • Perform Backup and Recover CDBs and PDBs
    • Duplicate an active PDB
    • Duplicate a Database
  • Manage Application PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
    • Explain the purpose of application root and application seed
    • Define and create application PDBs
    • Install, upgrade and Patch applications
    • Create and administer Application PDBS
    • Clone PDBs and Application containers
    • Plug and unplug operations with PDBs and application containers
    • Comparing Local Undo Mode and Shared Undo Mode
  • Recovery and Flashback - Oracle Database: Managing Multitenant Architecture Ed 1
    • Restore and Recovering Databases with RMAN
    • Perform CDB and PDB flashback
  • Backup Strategies and Terminology - Oracle Database: Backup and Recovery Workshop
    • Perform Full and Incremental Backups and Recoveries
    • Compress and Encrypt RMAN Backups
    • Use a media manager
    • Create multi-section backups of very large files
    • Create duplexed backup sets
    • Create archival backups
    • Backup of recovery files
    • Backup non database files
    • Back up ASM meta data
  • Restore and Recovery Concepts - Oracle Database: Backup and Recovery Workshop
    • Employ the best Oracle Database recovery technology for your failure situation
    • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry
  • Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop
    • Configure  your Database  to support Flashback
    • Perform flashback operations
  • Duplicating a Database - Oracle Database: Backup and Recovery Workshop
    • Duplicate Databases
  • Diagnosing Failures - Oracle Database: Backup and Recovery Workshop
    • Detect and repair database and database block corruption
    • Diagnosing Database Issues
  • Transporting Data - Oracle Database: Backup and Recovery Workshop
    • Transport Data
  • Install Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Install Grid Infrastructure for a Standalone server
    • Install Oracle Database software
  • Patching Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Patch Grid Infrastructure and Oracle Database
  • Upgrading to Oracle Grid Infrastructure - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Upgrade Oracle Grid Infrastructure
  • Oracle Database 18c: New Features - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Image and RPM based Database Installation
  • Oracle Restart - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Configure and use Oracle Restart to manage components
  • Install Grid Infrastructure for a Standalone server - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Rapid Home Provisioning
  • Using Availability Enhancements - Oracle Database 19c: New Features for Administrators
    • Use an RMAN recovery catalog
    • Use Flashback Database
  • Monitoring and Tuning Database Performance - Oracle Database: Administration Workshop
    • Managing Memory Components
    • Understanding The Automatic Workload Repository (AWR)
    • Understanding The Advisory Framework
    • Monitoring Wait Events, Sessions, and Services
    • Managing Metric Thresholds and Alerts
    • Understanding and Using The Performance Tuning Methodology
    • Performing Performance Planning
    • Understanding The Automatic Database Diagnostic Monitor (ADDM)
  • Manage CDBs and PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
    • Manage PDB service names and connections
    • Manage startup, shutdown and availability of CDBs and PDBs
    • Change the different modes and settings of PDBs
    • Evaluate the impact of parameter value changes
    • Performance management in CDBs and PDBs
    • Control CDB and PDB resource usage with the Oracle Resource Manager
  • Upgrading and Transporting CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1
    • Upgrade an Oracle Database
    • Transport Data
  • Manage Security in Multitenant databases - Oracle Database: Managing Multitenant Architecture Ed 1
    • Manage Security in Multitenant databases
    • Manage PDB lockdown profiles
    • Audit Users in CDBs and PDBs
    • Manage other types of policies in application containers
  • Configuring and Using RMAN - Oracle Database: Backup and Recovery Workshop
    • Configure RMAN and the Database for Recoverability
    • Configureand Using an RMAN recovery catalog
  • Performing Recovery - Oracle Database: Backup and Recovery Workshop
    • Restore and Recovering Databases with RMAN
    • Perform Non RMAN database recovery
  • RMAN Troubleshooting and Tuning - Oracle Database: Backup and Recovery Workshop
    • Interpret the RMAN message output
    • Diagnose RMAN performance issues
  • Creating an Oracle Database by using DBCA - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Create, Delete and Configure Databases using DBCA
  • Upgrade the Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop
    • Plan for Upgrading an Oracle Database
    • Upgrade an Oracle Database
    • Perform Post-Upgrade tasks
  • Using General Overall Database Enhancements - Oracle Database 19c: New Features for Administrators
    • Install Oracle Database software
    • Create, Delete and Configure Databases using DBCA
    • Creating CDBs and Regular PDBs
    • Use Miscellaneaous 19c New Features
  • Using Diagnosibility Enhancements - Oracle Database 19c: New Features for Administrators
    • Use new Diagnoseability Features
  • Tuning SQL Statements - Oracle Database: Administration Workshop
    • Understanding The Oracle Optimizer
    • Using The SQL Tuning Advisor
    • Managing Optimizer Statistics
    • Using The SQL Access Advisor
    • Understanding The SQL Tuning Process

Exam Preparation Resources

There are a number of resources available to help you prepare for the Oracle Database 11g Administrator Certified Professional examination:

An additional resource is O'Reilly Learning Safari Books Online, a searchable digital library that provides online access to thousands of books, training videos and conference sessions. See the Educational Resources section on the Related Sites page here on COOL to learn how to get free access.

Testing Information

  • Exam Administration

    Credential exams may be administered in-person at a testing site, proctored on-line remotely, or have options for both. If an exam is administered through a test vendor, the third-party test vendor box will be checked. The following test administration options apply to the Oracle Database 11g Administrator Certified Professional credential where checked:

    • In-person exam
    • Remote proctored on-line exam
    • Third-party test vendor
  • For more information on the Oracle Corporation testing process, visit the agency website.

RECERTIFICATION

Oracle Database 11g Administrator Certified Professional

Renewal Period: Not Renewable

The Oracle Database 11g Administrator Certified Professional credential has the following recertification information:

  • Certification credentials will be current or retired according to their version (e.g 9i, 10g, 11g, 12c etc.).

    Candidates who hold an Oracle Certified Database Administrator Associate, Professional, Expert and/or Master credential on a retired version have 12 months to to earn a credential on a current (non-retired) version of Oracle Database to remain in active status. All candidates that hold Oracle Database credential in active status will have all their credentials remain in active status, even if the credentials are retired.

In Demand

This certification is considered in demand. The U.S. Department of Labor sponsored CareerOneStop's analysis indicates the certification is frequently mentioned in online job postings.

Click for external link to CareerOneStop's Credentials Center.

COOL Bucks

See your installation Education Service Officer for credential exam information and coordinating instructions.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

Some

Credential is related to some tasks associated with the duties of the military occupation (at least one critical task but less than 80%)

Most

Credential is directly related to most of the major duties associated with the military occupation (at least 80%)

Other

Credential is related to this military occupation, but is more advanced or specialized and therefore will likely require additional education, training, or experience

CA Eligible

This certification is eligible for CA.

Promotion Points

This certification has been approved for promotion points.

Click for more information.

Star

Star credentials are MOS enhancing, as designated by the Proponent. MOS enhancing credentials are directly related to an MOS or ASI, are taught either partially or completely as part of a Program of Instruction (POI), and improves the MOS technical proficiency.

Skill Level

The Skill Level reflects the level, based on MOS training and/or experience, the Soldier should be the most prepared to successfully earn the credential. See the Table Legend for details about each level.

Proponent Funded

Indicates the credential may have funding through the MOS proponent. Some proponents offer credentialing opportunities in conjunction with military training and/or as part of MOS development beyond the training base.

Click for more information.

Navy Bucks

Credential voucher or reimbursement for credential exam, re-certification, or maintenance fee has been approved for payment through the Navy's Credential Program Office. To get a voucher request form, click Menu at the top of any page, then click "2 Complete Voucher and Apply" under Credentialing Steps.

CG Bucks

Current Coast Guard policy states all credentials listed on CG COOL may be reimbursed assuming the enlisted service member meets the eligibility requirements as outlined in the Coast Guard Voluntary Credentialing Program Policy (COMDTINST 1540.1(series))

Early Career

1-3 years experience; Enlisted E1 through E4

Mid Career

4-10 years experience; Enlisted E5 through E6

Late Career

10+ years experience; Enlisted E7 through E9

Early Career

1-3 years experience; Enlisted “A” School through E5

Mid Career

4-10 years experience; Enlisted E6 through E7

Late Career

10+ years experience; Enlisted E8 through E9

Early Career

1-6 years experience; Officer O1 through O2

Mid Career

6-12 years experience; Officer O3 through O5

Late Career

12+ years experience; Officer O6 and Above

GI Bill®

Reimbursement for exam fees has been approved for payment through the GI Bill.

Note: GI Bill approval data is updated quarterly. For the latest information, visit the WEAMS Licenses/Certifications Search page. Make sure to select "Both" in the LAC Category Type drop-down before searching.

Click to go to the external link for GI Bill licensing and certification information.

ANAB (ANSI)

This credential has been accredited by ANAB (ANSI).

Click to go to the external ANAB web site.

ICAC

This credential has been accredited by ICAC.

Click to go to the external ICAC web site.

ABSNC

This credential has been accredited by ABSNC.

Click to go to the external ABSNC web site.

NCCA

This credentialing program has been accredited by NCCA.

Click to go to the external NCCA web site.

IAS

This credential has been accredited by IAS.

Click to go to the external IAS web site.

Low

May be difficult to attain: minimum education requirement is a Bachelor's degree, and/or minimum experience is 10 or more years.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

Medium

Moderate ease of attainment: minimum education requirement = Associate's and/or prerequisite and/or minimum experience = more than 2 years and less than 10 years of experience.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

High

Highly attainable: minimum education requirement = HS or less and/or minimum experience = 2 years or less experience and no additional requirements.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

MOS is Military Occupational Specialty
ASI is Additional Skill Identifier
WOMOS is Warrant Officer Military Occupational Specialty
AOC is Area Of Concentration Officer
Functional Area
Branch

Army e-learning

State-of-the art Computer Based Training available for free to the Army Workforce. Click for more information.

Click here for more information.

NKO e-learning

$$ELEARN_NKO_DESC$$

Bright Outlook – new job opportunities are very likely in the future for this job

Registered Apprenticeship

An apprenticeship program is registered with the U.S. Department of Labor. Go to the Apprenticeship Finder and enter career path or location to find apprenticeship opportunities.

Click here for External link to: My Next Move for Veterans - Database Administrators
Click here for External link to: My Next Move salary info for Database Administrators

Bright Outlook – new job opportunities are very likely in the future for this job

Click here for external link to: My Next Move for Veterans State Map for Database Administrators

This is an official U.S. Army website
Updated: March 31, 2021
Top