- Manage Materialized Views to improve rewrite and refresh performance
- Configure and manage distributed materialized views
- Create and Manage encrypted tablespaces
- Manage Transport of tablespaces across platforms
- Configure a schema to support a star transformation query
- Administer external tables
- Implement Data Pump export and import jobs for data transfer
- Implement Data Pump to and from remote databases
- Configure and use parallel execution for queries
- Use SQL*Loader
- Administer, manage and tune parallel execution