Database 12c

Oracle Database 12c Essentials

The Oracle Database 12c Essentials Exam (1Z0-497) is designed for individuals who possess a strong foundation and expertise in selling and implementing Oracle Database 12c solutions. This certification covers topics such as: Installing and Creating a Database, Using Oracle Enterprise Manager Database Express and SQL-Based Management Tools, Configuring the Oracle Network Environment, Managing the Oracle Instance, Managing Database Storage Structures, Administering Users and Security, Managing Schema Objects, Performing Backup and Recovery, Managing the Database and Using Advisors and Managing Oracle Database Software. The exam is based on the Oracle Database 12c Release 1 Concepts. This certification differentiates candidates in the marketplace by providing a competitive edge through proven expertise. Up-to-date training and field experience are recommended.

This certification is available to all candidates but is geared toward members of the Oracle PartnerNetwork. OPN members earning this certification will be recognized as OPN Certified Specialists. This certification qualifies as competency criteria for the Oracle Database 12c specialization.

Exam Number:
120 minutes
Associated Certifications:
Oracle Database 12c Certified Implementation Specialist

OPN Certified Specialist
Number of
Exam Price:
US$ 245

More on exam pricing

Passing score subject to change. View Details.
Exam Validation:
Exam validated against release 12c
Exam Format:
Multiple Choice


Recommended Training and Preparation Additional Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training

OPN Guided Learning Path
Oracle Database 12c Exam Study Guide
Oracle Database 12c Implementation Specialist


Additional Training
Oracle Database 12c: New Features for Administrators (training)
Oracle Database: Introduction to SQL (training)
Oracle Database: SQL Workshop I (training)
Oracle Database: SQL and PL/SQL Fundamentals (training)
Oracle Database 12c: Admin, Install and Upgrade Accelerated (training)
Oracle Database 12c: Backup and Recovery Workshop (training)
Oracle Database 12c: Managing Multitenant Architecture (training)


Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)


Exam Topics

Oracle Database Software

  • Describe the key characteristics of a relational database
  • Summarize locking behavior in an Oracle database
  • Describe the differences between data concurrency and data consistency
  • Describe the various steps of a database transaction

Administration & Configuration

  • Design a database, identify requirements, create the logical design and physical database design
  • Install and configure a database
  • Grant Enterprise Manager administrative privileges
  • Use SQL*Plus and SQL Developer to access your database

Oracle Database 12c New Features

  • Setup a Global Database Service (GDS)
  • Define declarative policies for Oracle Data Redaction
  • Apply best practices for running the ADDM Advisor

Maximum Availability Architecture

  • Implement the various Data Guard configurations available
  • Explain the architectural differences between Data Guard and Active Data Guard
  • Implement the various replication options available to the Oracle database
  • Create an MAA architecture that leverages Active Data Guard and Oracle Golden Gate
  • Choose the appropriate high availability architecture based on various planned and unplanned scenarios

Backup and Recovery

  • Explain general best practices and guidelines for backups on the Oracle database
  • Implement recovery procedures for various failure scenarios
  • Use the Data Recovery Advisor for backup and recovery solutions


  • Use Oracle Enterprise Manager to view database storage structures
  • Apply different strategies for interacting with the database using SQL Developer
  • Describe the EM Cloud Control and EM Express architecture as it relates to the database
  • Manage structures used to undo changes made to the database and maintain data consistency

Administering Users and Security

  • Create and administer users
  • Grant privileges to users to perform database operations
  • Create and manage roles

Software Installation and Maintenance

  • Install the Oracle database software
  • Locate patches for the Oracle database
  • Apply best practices to patching the database
  • Apply troubleshooting tasks for planned database maintenance
  • View and modify the parameters used to configure the Oracle instance

Oracle Data Structure

  • Articulate the various schema objects in a relational database
  • Perform different index scans and relate them to index types
  • Leverage partitioning in an Oracle database
  • Use the data dictionary and the dynamic performance views
  • Identify the various tools for data movement and analysis

Oracle Database Instance Architecture

  • Define the main components of an Oracle Instance
  • Describe the various stages of a database instance
  • Articulate the various basic memory structures
  • Describe how a block of data is written to the database
  • Articulate the mandatory background processes

Oracle Multitenant Architecture

  • Explain the benefits of multitenant architecture for database consolidation
  • Create a pluggable database (PDB)
  • Articulate the difference between a Container database and a Pluggable database
  • Perform administration tasks on a container database (CDB)
  • Manage processes in a CDB
  • Manage physical and logical structures in a CDB
  • Describe the various storage options for a PDB

Oracle Network Architecture

  • Describe the difference between Shared Server and Dedicated Server architecture as it relates to Oracle Connection Manager
  • Describe the Oracle Database listener architecture
  • Configure and connect to a database service
  • Configure a database listener


Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View (PDF) the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.



 E-mail this page  Printer View