1. Exploring the Oracle Database Architecture
- Explain the Memory Structures
- Describe the Process Structures
- Overview of Storage Structures
2. Preparing the Database Environment- Identify the tools for Administering an Oracle Database
- Plan an Oracle Database installation
- Install the Oracle software by using Oracle Universal Installer (OUI)
3. Creating an Oracle Database- Create a database by using the Database Configuration Assistant (DBCA)
4. Managing the Oracle Instance- Setting database initialization parameters
- Describe the stages of database startup and shutdown
- Using alert log and trace files
- Using data dictionary and dynamic performance views
5. Configuring the Oracle Network Environment- Configure and Manage the Oracle Network
- Using the Oracle Shared Server architecture
6. Managing Database Storage Structures- Overview of tablespace and datafiles
- Create and manage tablespaces
- Space management in tablespaces
7. Administering User Security- Create and manage database user accounts
- Grant and revoke privileges
- Create and manage roles
- Create and manage profiles
8. Managing Data and Concurrency- Monitor and resolve locking conflicts
9. Managing Undo Data- Overview of Undo
- Transactions and undo data
- Managing undo
10. Implementing Oracle Database Security- Database Security and Principle of Least Privilege
- Work with Standard Database Auditing
11. Database Maintenance- Use and manage optimizer statistics
- Use and manage Automatic Workload Repository (AWR)
- Use advisory framework
- Manage Alerts and Thresholds
12. Performance Management- Use Automatic Memory Management
- Use Memory Advisors
- Troubleshoot invalid and unusable objects
13. Intelligent Infrastructure Enhancements- Use the Enterprise Manager Support Workbench
- Managing Patches
14. Backup and Recovery Concepts- Identify the types of failure that can occur in an Oracle database
- Describe ways to tune instance recovery
- Identify the importance of checkpoints, redo log files, and archived log files
- Overview of flash recovery area
- Configure ARCHIVELOG mode
15. Performing Database Backups- Create consistent database backups
- Back up your database without shutting it down
- Create incremental backups
- Automate database backups
- Manage backups, view backup reports and monitor the flash recovery area
16. Performing Database Recovery- Overview of Data Recovery Advisor
- Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
17. Moving Data- Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
- Explain the general architecture of Oracle Data Pump
- Use Data Pump Export and Import to move data between Oracle databases