Architecture
[ ] Outline the Oracle Architecture and its main Components
[ ] Explain the Oracle instance architecture

Installing the Oracle Database Software
[ ] Identify common database administrative tools available to a DBA (1)
[ ] Use optimal flexible architecture
[ ] Install software with Oracle Universal Installer
[ ] Identify and configure commonly used environment variables
[ ] Use Installer Log (2)

Creating an Oracle Database
[ ] Use DBCA to Create a database
[ ] Use DBCA to Delete a database
[ ] Use DBCA to manage templates

Managing the Oracle Instance
[ ] Use Enterprise Manager
[ ] Use SQL*Plus and iSQL*Plus to access the Oracle Database
[ ] Modify database initialization parameters
[ ] Describe the stages of database startup
[ ] Describe the database shutdown options
[ ] View the database alert log
[ ] Use dynamic performance views (3)

Managing Database Storage Structures
[ ] Describe how table row data is stored in blocks (4)
[ ] Define the purpose of tablespaces and data files
[ ] Explain space management in tablespaces
[ ] Create tablespaces
[ ] Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL
[ ] Obtain tablespace information
[ ] Explain key features and benefits of ASM (5)

Administering User Security
[ ] Create and manage database user accounts
[ ] Create and manage roles
[ ] Grant and revoke privileges
[ ] Create and manage profiles (6)
 Managing Schema Objects
[ ] Create and modify tables
[ ] Define constraints and states of constraints (7)
[ ] Dropping and truncating tables (7)
[ ] Create and use B-Tree and Bitmap indexes (8)
[ ] Create Views
[ ] Create sequences
[ ] Use data dictionary

Managing Data and Concurrency
[ ] Manipulate data through the use of SQL
[ ] Identify and administer PL/SQL objects
[ ] Describe triggers and triggering events
[ ] Define levels of locking
[ ] List possible causes of lock conflict
[ ] Monitor and resolve lock conflicts

Managing Undo Data
[ ] Monitor and administer undo
[ ] Configure undo retention
[ ] Describe the relationship between undo and transactions
[ ] Size the undo tablespace

Implementing Oracle Database Security
[ ] Apply the principle of least privilege
[ ] Audit database activity
[ ] Implement Fine-Grained Auditing

Configuring the Oracle Network Environment
[ ] Use Database Control to Create additional listeners
[ ] Use Database Control to Create Oracle Net service aliases
[ ] Control Oracle Net Listeners
[ ] Identify when to use shared servers versus dedicated servers

Proactive Maintenance
[ ] Gather optimizer statistics
[ ] Manage the Automatic Workload Repository
[ ] Use the Automatic Database Diagnostic Monitor (ADDM)
[ ] Set warning and critical alert thresholds
[ ] React to performance issues
 Performance Management
[ ] Use enterprise manager to view performance (9)
[ ] Tune SQL by using SQL tuning advisor (10)
[ ] Tune SQL by using SQL access advisor
[ ] Use automatic shared memory management (11)
[ ] Use the memory advisor to size memory buffer (11)

Backup and Recovery Concepts
[ ] Describe the types of failure that may occur in an Oracle Database
[ ] Identify the importance of checkpoints, redo log files, and archived log files
[ ] Tuning instance recovery
[ ] Configure a database for recoverability
[ ] Configure ARCHIVELOG mode

Performing Database Backup
[ ] Create consistent database backups
[ ] Back up your database without shutting it down
[ ] Create incremental backups
[ ] Automate database backups
[ ] Backup a control file to trace
[ ] Monitor flash recovery area

Performing Database Recovery
[ ] Recover from loss of a Control file
[ ] Recover from loss of a Redo log file
[ ] Recover from loss of a system-critical data file
[ ] Recover from loss of a non system-critical data file

Performing Flashback
[ ] Describe flashback database (12)
[ ] Resotore the table contents to a specific point in time (12)
[ ] Recover from a dropped table (12)
[ ] Use Flashback Query to view the contents of the database as of any single point of time (12)
[ ] View transaction history or row with flashback transaction query (12)

Moving Data
[ ] Describe the general architecture of Data Pump (13)
[ ] Use Data Pump export and import to move data between Oracle databases
[ ] Load data with SQL Loader (14)
[ ] Use external tables to move data (14)