Oracle 1Z0-062 Certification Exam Syllabus

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 (Pricing may vary by country or by localized currency)
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 Training
Schedule Exam Pearson VUE - Oracle
Recommended Practice Email Macro.net for Free Practice Sessions

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

The Oracle 1Z0-062 Certification Program certifies candidates on skills and knowledge related to Oracle Database products and technologies. The Oracle Database 12c Administrator Certified Associate is granted based on a combination of passing exams, training and performance-based assignments, depending on the level of certification. Oracle 1Z0-062 certification is tangible benchmark of experience and expertise that help you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exam and hands-on experience to prepare for your Oracle Database 12c Administration certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.