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
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
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