1Z0-062: Oracle Database 12c Administration


Exam Number: 1Z0-062

Exam Title: Oracle Database 12c Administration


Associated Certification Paths



Oracle 1Z0-062 Certification Details:


Exam Name Oracle Database 12c Administration
Exam Code 1Z0-062
Exam Product Version Oracle Database 12c
Exam Price USD $245
Duration 120 minutes
Number of Questions 67
Passing Score 64% 
Validated Against This exam has been validated against Oracle Database 12.1.0.1.0.
Format Multiple Choice
Recommended Practice 1Z0-062 Online Practice Exam
Recommended Training Oracle Database 12c: Administration Workshop

Oracle 1Z0-062 Certification Topics:



Exploring the Oracle Database Architecture
  • List the architectural components of Oracle Database
  • Explain the memory structures
  • Describe the background processes
Oracle Database Management Tools
  • Use database management tools
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
  • Configure communication between databases
Administering User Security
  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles
Managing Database Storage Structures
  • Describe the storage of table row data in blocks
  • Create and manage tablespaces
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 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
Managing Data Concurrency
  • Describe the locking mechanism and how Oracle manages data concurrency
  • Monitor and resolve locking conflicts
Implementing Oracle Database Auditing
  • Enable standard database auditing and unified auditing
Backup and Recovery Concepts
  • Identify the importance of checkpoints, redo log files, and archive log files
Backup and Recovery Configuration
  • Configure the fast recovery area
  • Configure ARCHIVELOG mode
Performing Database Backups
  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Manage backups
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
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
Performing Database Maintenance
  • Use server-generated alerts
Managing Performance: SQL Tuning
  • Use the SQL Tuning advisor
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
Creating an Oracle Database Using DBCA 
  • Generate database creation scripts by using DBCA 
  • Manage database design templates by using DBCA
Upgrading Oracle Database Software  
  • Describe data migration methods
  • Describe the upgrade process
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 1Z0-062 - Oracle Database 12c Administration Exam Preparation: