Oracle Corporation

Oracle Database 12c Administrator Certified Associate

Credential: Oracle Database 12c Administrator Certified Associate  Army eLearning resource CA Eligible
Credentialing Agency: Oracle Corporation

Renewal Period: Within 12 months of certification retirement

An Oracle Certified Associate (OCA) 12c Database Administrators certification emphasizes the full set of skills that DBAs need in today's competitive marketplace. The certification assesses the most important skills DBAs need for daily operational management and maintenance. Candidates must pass two multiple choice exams.

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

Oracle Database 12c Administrator Certified Associate

MINIMUM REQUIREMENTS

Attainability:    high

Eligibility Requirements 

  • Credential Prerequisite
  • 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.

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: Within 12 months of certification retirement

  • 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

Show Written Exam Requirements / Hide Written Exam Requirements

  • Exploring the Oracle Database Architecture
    • List the architectural components of Oracle Database
    • Explain the memory structures
    • Describe the background processes
  • Oracle Database Instance
    • Understand initialization parameter files
    • Start up and shut down an Oracle database instance
    • View the alert log and access dynamic performance views
  • Administering User Security
    • Create and manage database user accounts
    • Grant and revoke privileges
    • Create and manage roles
    • Create and manage profiles
  • Create and manage tablespaces
    • Explain how Oracle database server automatically manages space
    • Save space by using compression
    • Use the Segment Advisor
    • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Managing Data Concurrency
    • Describe the locking mechanism and how Oracle manages data concurrency
    • Monitor and resolve locking conflicts
  • Backup and Recovery Concepts
    • Identify the importance of checkpoints, redo log files, and archive log files
  • Performing Database Backups
    • Create consistent database backups
    • Back up your database without shutting it down
    • Create incremental backups
    • Automate database backups
    • Manage backups
  • Moving Data
    • Describe ways to move data
    • Use SQL*Loader to load data from a non-Oracle database
    • Use external tables to move data via platform-independent files
    • Explain the general architecture of Oracle Data Pump
    • Use Data Pump Export and Import to move data between Oracle databases
  • Managing Performance: SQL Tuning
    • Use the SQL Tuning advisor
  • Creating an Oracle Database Using DBCA
    • Generate database creation scripts by using DBCA
    • Manage database design templates by using DBCA
  • Introduction to DBAAS
    • Recognize the difference between a DBaaS Instance and a Database Instance
    • Navigate with My Services Dashboard
    • User authentication and roles
    • Generate a Secure Shell (SSH) Public/Private Key Pair
  • Oracle Database Management Tools
    • Use database management tools
  • Configuring the Oracle Network Environment
    • Configure Oracle Net Services
    • Use tools for configuring and managing the Oracle network
    • Configure client-side network
    • Configure communication between databases
  • Managing Database Storage Structures
    • Describe the storage of table row data in blocks
    • Create and manage tablespaces
  • Managing Undo Data
    • Explain DML and undo data generation
    • Monitor and administer undo data
    • Describe the difference between undo data and redo data
    • Configure undo retention
  • Implementing Oracle Database Auditing
    • Enable standard database auditing and unified auditing
  • Backup and Recovery Configuration
    • Configure the fast recovery area
    • Configure ARCHIVELOG mode
  • Performing Database Recovery
    • Determine the need for performing recovery
    • Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file
  • Performing Database Maintenance
    • Use server-generated alerts
  • Automating Tasks by Using Oracle Scheduler
    • Use Oracle Scheduler to simplify management tasks
    • Use job chains to perform a series of related tasks
    • Use Scheduler jobs on remote systems
    • Use advanced Scheduler features to prioritize jobs
  • Upgrading Oracle Database Software
    • Describe data migration methods
    • Describe the upgrade process

  • Relational Database concepts
    • Explaining the theoretical and physical aspects of a relational database
    • Relating clauses in SQL Select Statement to Components of an ERD
    • Explaining the relationship between a database and SQL
  • Restricting and Sorting Data
    • Applying Rules of precedence for operators in an expression
    • Limiting Rows Returned in a SQL Statement
    • Using Substitution Variables
    • Using the DEFINE and VERIFY commands
    • Sorting Data
  • Using Conversion Functions and Conditional Expressions
    • Applying the NVL, NULLIF, and COALESCE functions to data
    • Understanding implicit and explicit data type conversion
    • Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    • Nesting multiple functions
  • Displaying Data from Multiple Tables
    • Using Self-joins
    • Using Various Types of Joins
    • Using Non equijoins
    • Using OUTER joins
    • Understanding and Using Cartesian Products
  • Using SET Operators
    • Matching the SELECT statements
    • Using the ORDER BY clause in set operations
    • Using The INTERSECT operator
    • Using The MINUS operator
    • Using The UNION and UNION ALL operators
  • Managing Indexes Synonyms and Sequences
    • Managing Indexes
    • Managing Synonyms
    • Managing Sequences
  • Managing Views
    • Managing Views
  • Managing Objects with Data Dictionary Views
    • Using data dictionary views
  • Retrieving Data using the SQL SELECT Statement
    • Using Column aliases
    • Using The SQL SELECT statement
    • Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    • Using Arithmetic expressions and NULL values in the SELECT statement
  • Using Single-Row Functions to Customize Output
    • Manipulating strings with character functions in SQL SELECT and WHERE clauses
    • Performing arithmetic with date data
    • Manipulating numbers with the ROUND, TRUNC and MOD functions
    • Manipulating dates with the date function
  • Reporting Aggregated Data Using Group Functions
    • Restricting Group Results
    • Creating Groups of Data
    • Using Group Functions
  • Using Subqueries to Solve Queries
    • Using Single Row Subqueries
    • Using Multiple Row Subqueries
    • Update and delete rows using correlated subqueries
  • Managing Tables using DML statements
    • Managing Database Transactions
    • Controlling transactions
    • Perform Insert, Update and Delete operations
    • Performing multi table Inserts
    • Performing Merge statements
  • Use DDL to manage tables and their relationships
    • Describing and Working with Tables
    • Describing and Working with Columns and Data Types
    • Creating tables
    • Dropping columns and setting column UNUSED
    • Truncating tables
    • Creating and using Temporary Tables
    • Creating and using external tables
    • Managing Constraints
  • Controlling User Access
    • Differentiating system privileges from object privileges
    • Granting privileges on tables
    • Distinguishing between granting privileges and roles
  • Managing Data in Different Time Zones
    • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
    • Working with INTERVAL data types

Exam Preparation Resources

There are a number of resources available to help you prepare for the Oracle Database 12c Administrator Certified Associate 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 12c Administrator Certified Associate 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 12c Administrator Certified Associate

Renewal Period: Within 12 months of certification retirement

The Oracle Database 12c Administrator Certified Associate credential has the following recertification information:

  • Certain Oracle credentials require periodic recertification in order for Oracle to recognize them as "active". For such credentials, candidates must upgrade to a current version within twelve (12) months following Oracle's credential retirement to keep his or her certification in active status. Specific upgrade requirements for each credential will vary and Oracle will notify affected candidates of the applicable upgrade requirements upon credential retirement. Oracle requires candidates to hold an active credential in order to access certain certification benefits including, without limitation, use of Oracle certification logos, eCertificates, score reports, digital badges and certification verification.

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