Download PDF
of this course

Certification Exam Prep Seminar: Oracle Database 12c: Install and Admin (EPDB12CIA)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 1 Day

Price: SGD 322.00

This exam prep seminar helps you prepare to take the Oracle Database 12c: Install and Admin certification exam.

  • Oracle Database 12c: Installation and Administration (1Z0-062)

*Prices are subject to change based on location.

Exam Prep Seminars:

  • Provide a thorough review of exam objectives.
  • Illustrate the breadth of topics and skills necessary to pass the exam.
  • Give exclusive tips and strategies to prepare for the certification exam.
  • Increase confidence.

This seminar is for exam review purposes only and does not meet the Hands-on Course training requirement (if applicable to your certification track). We recommend that candidates who have no experience or have not completed any relevant training, opt for the associated training package instead.


Who Should Attend

  • Database Administrators
  • Project Manager
  • Sales Consultants
  • Technical Consultant

Course Certifications

This course is part of the following Certifications:


Course Objectives

  • Review key technologies and certification concepts related to Oracle Database 12c: Advanced Administration.
  • Understand the depth and breadth of the Oracle Database Administrator.
  • Get information that will help you complete your preparation and study.
  • Receive tips and information that will help you on the test.
  • Learn from one of Oracle University's top instructors.

Course Content

Exploring the Oracle Database Architecture

  • List the architectural components of Oracle Database
  • Explain the memory structures
  • Describe the background processes
  • Explain the memory structures

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

Configuring the Oracle Network Environment

  • Configure Oracle Net Services
  • Use tools for configuring and managing the Oracle network
  • Configure client-side network
  • Troubleshoot network issues
  • Configure communication between databases
  • Configure shared servers

Monitoring and Managing Memory

  • Implement Automatic Memory Management
  • Implement Automatic Shared Memory Management
  • Manually configure SGA parameters for various memory components in the SGA
  • Use Automatic PGA Memory Management

Storage Management

  • Describe the storage of table row data in blocks
  • Create and manage tablespaces
  • Create and maintain bigfile tablespaces
  • Rename tablespaces
  • Create a default permanent tablespace
  • Relocate SYSAUX occupants

Space Management

  • Explain how Oracle database server automatically manages space
  • Save space by using compression
  • Proactively monitor and manage tablespace space usage
  • Use the Segment Advisor

Resumable Space Allocation and Segment Shrinking

  • Manage resumable space allocation
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Undo Data

  • Explain DML and undo data generation
  • Describe the difference between undo data and redo data
  • Monitor and administer undo data
  • Configure undo retention
  • Use automatic undo retention tuning and temporary undo

Managing Data Concurrency

  • Describe the locking mechanism and how Oracle manages data concurrency
  • Monitor and resolve locking conflicts


  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles


  • Explain DBA responsibilities for security and auditing
  • Enable standard database auditing and unified auditing
  • Enable and configure Unified Audit Data Trail

Automatic Storage Management

  • Automatic Storage Management
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM diskgroups
  • Set up ASM fast mirror resync
  • Execute SQL commands with ASM file names
  • Use the ASMCMD command-line interface

Backup and Recovery Concepts

  • Identify the importance of checkpoints, redo log files, and archive log files
  • Configure ARCHIVELOG mode

Configuring Recovery Manager

  • Create and maintain the Fast Recovery Area
  • Configure database parameters that affect RMAN operations
  • Change RMAN default settings with CONFIGURE
  • Manage RMAN's persistent settings
  • Start the RMAN utility and allocate channels

Basics of Using RMAN to Create Backups

  • Create backupsets and image copies
  • Create a whole database backup
  • Perform full and incremental backups
  • Enable fast incremental backup
  • Report on and maintain backups

Performing Recovery

  • Determine the need for performing recovery
  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Recover the control file
  • Recover a redo log group member

Loading and Unloading Data

  • Describe ways to move data
  • Use SQL*Loader to load data from a non-Oracle database
  • Explain Data Pump architecture
  • Use Data Pump export and import
  • Monitor a Data Pump job
  • Use Oracle Data Pump enhancements (in 12c)
  • Create external tables for data population
  • Use SQL*Loader and External table enhancements (in 12c)

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
  • Monitor the Resource Manager

Proactive Performance Management

  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use automated tasks
  • Manage optimizer statistics
  • Use the Memory Advisor to size memory buffers
  • Use the Redo Logfile Size Advisor

Using the SQL Tuning and Access Advisor

  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload

Automating Tasks with the Scheduler

  • Use Oracle Scheduler to simplify management tasks
  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Use job chains to perform a series of related tasks
  • Create lightweight jobs
  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs
  • Use Scheduler jobs on remote systems

Installing Oracle Database 12c

  • Plan for an Oracle Database software installation
  • Install Oracle Grid Infrastructure for a stand-alone server
  • Install Oracle Database software
  • Use OUI and DBCA for installation and configuration
  • Use Oracle Restart
  • (View the full list of topics on the exam page at>View All Exams)


Course ID: EPDB12CIA

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register