Architecture
- Oracle Architecture
- Instance architecture
- Install software
- Configure
Managing Instance
- Enterprise Manager
- SQL*Plus and iSQL*Plus
- Stages of database startup
- Database shutdown options
Database Structures
- Create tablespaces
- Manage tablespaces
- Obtain tablespace
User Security
- Create and manage roles
- Grant and revoke privileges
- Create and manage profiles
- Create and modify tables
- Constraints
- Dropping and truncating
- Create and use B-Tree and Bitmap
Implementing Oracle Database Security
- Audit database activity
- Implement Fine-Grained Auditing
|
Managing Data and Concurrency
- Identify and administer PL/SQL objects
- Describe triggers
- Levels of locking
- Lock conflict
- Monitor and resolve
Managing Undo Data
- Monitor and administer undo
- Configure undo retention
- Size the undo tablespace
Performing Database Backup
- Create consistent database backups
- Back uP
- Create incremental backups
- Automate database backups
- Backup a control file to trace
- Monitor flash recovery area
Database Recovery
- Control file
- Redo log file
- System-critical data file
- Non system-critical data file
|
