OCA 1Z0-062

Exploring the Oracle Database Architecture

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

Oracle Database Instance

• Understand initialization parameter files – POST I
• Start up and shut down an Oracle database instance – POST I
• View the alert log and access dynamic performance views – POST I, POST II

Administering User Security

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

Create and manage tablespaces

• Explain how Oracle database server automatically manages space – POST I, POST II, POST III, POST IV, POST V, POST VI, POST VII, POST VIII, POST IX
• Save space by using compression – POST I
• Use the Segment Advisor – POST I
• Reclaim wasted space from tables and indexes by using the segment shrink functionality – POST I

Managing Data Concurrency

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

Backup and Recovery Concepts

• Identify the importance of checkpoints, redo log files, and archive log files – POST I, POST II

Performing Database Backups

• Create consistent database backups – POST I
• Back up your database without shutting it down – POST I
• Create incremental backups – POST I
• Automate database backups – POST I
• Manage backups – POST I

Moving Data

• Describe ways to move data
• Use SQL*Loader to load data from a non-Oracle database – POST I
• Use external tables to move data via platform-independent files – POST I
• Explain the general architecture of Oracle Data Pump – POST I
• Use Data Pump Export and Import to move data between Oracle databases – POST I

Managing Performance: SQL Tuning

• Use the SQL Tuning advisor – POST I

Creating an Oracle Database Using DBCA 

• Generate database creation scripts by using DBCA – POST I
• Manage database design templates by using DBCA – POST I

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 – POST I
• Use tools for configuring and managing the Oracle network – POST I
• Configure client-side network – POST I
• Configure communication between databases – POST I

Managing Database Storage Structures

• Describe the storage of table row data in blocks – POST I
• Create and manage tablespaces – POST I, POST II

Managing Undo Data

• Explain DML and undo data generation – POST I
• Monitor and administer undo data – POST I
• Describe the difference between undo data and redo data – POST I
• Configure undo retention – POST I

Implementing Oracle Database Auditing

• Enable standard database auditing and unified auditing – POST I

Backup and Recovery Configuration

• Configure the fast recovery area – POST I
• Configure ARCHIVELOG mode – POST I

Performing Database Recovery

• Determine the need for performing recovery – POST I
• Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file – POST I

Performing Database Maintenance

• Use server-generated alerts – POST I

Automating Tasks by Using Oracle Scheduler

• Use Oracle Scheduler to simplify management tasks – POST I
• Use job chains to perform a series of related tasks – POST I
• Use Scheduler jobs on remote systems – POST I
• Use advanced Scheduler features to prioritize jobs – POST I

Upgrading Oracle Database Software  

• Describe data migration methods – POST I
• Describe the upgrade process – POST I, POST II, POST III