- Administering User Security
- Create and manage database user accounts
- Grant and revoke privileges
- Create and manage roles
- Create and manage profiles
- Managing Space
- Explain how Oracle database server automatically manages space
- Save space by using compression
- Proactively monitor and manage tablespace space usage
- Use the Segment Advisor
- Reclaim wasted space from tables and indexes by using the segment shrink functionality
- Manage resumable space allocation
- Managing Undo Data
- Explain DML and undo data generation
- Monitor and administer undo data
- Describe the difference between undo data and redo data
- Configure undo retention
- Managing Data Concurrency
- Describe the locking mechanism and how Oracle manages data concurrency
- Monitor and resolve locking conflicts
- Implementing Oracle Database Auditing
- Explain DBA responsibilities for security and auditing
Enable standard database auditing and unified auditing