- Leveraging Multitenant Enhancements
Use refreshable copy PDB switchover
Benefit from dynamic container map
Manage PDB snapshots carousel
Manage application PDBs fleet
Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
- Managing Security
Configure encryption of sensitive data in Database Replay files
Export and import database links
Create and use a schema only account
Explain direct Active Directory Services integration
Isolate PDB keystores
- Using RMAN Enhancements
Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted
- Applying General Database Enhancements
Merging of partitions and subpartitions online
Generate batched DDL by using DBMS_METADATA_DIFF package
Manage private temporary tables
Online modification of partitioning and subpartitioning strategy
Use the new Data Pump Import option of the DATA_OPTIONS parameter
- Improving Performance
Describe the new SQL Tuning Set package
Use IMEs window capture
Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
Configure Automatic In-Memory
- Handling Enhancements in Big Data and Data Warehousing
Use analytic view new query capabilities
Query inlined external tables and manage in-memory external tables
Create and use polymorphic table functions
- Describing Sharding Enhancements
Understand support for PDBs as shards
Describe Oracle GoldenGate enhancements for Oracle Sharding support
Describe improved multi-shard query enhancements
Query system objects across shards
Describe the user-defined sharding method
Use refreshable copy PDB switchover
Benefit from dynamic container map
Manage PDB snapshots carousel
Manage application PDBs fleet
Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
- Managing Security
Configure encryption of sensitive data in Database Replay files
Export and import database links
Create and use a schema only account
Explain direct Active Directory Services integration
Isolate PDB keystores
- Using RMAN Enhancements
Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted
- Applying General Database Enhancements
Merging of partitions and subpartitions online
Generate batched DDL by using DBMS_METADATA_DIFF package
Manage private temporary tables
Online modification of partitioning and subpartitioning strategy
Use the new Data Pump Import option of the DATA_OPTIONS parameter
- Improving Performance
Describe the new SQL Tuning Set package
Use IMEs window capture
Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
Configure Automatic In-Memory
- Handling Enhancements in Big Data and Data Warehousing
Use analytic view new query capabilities
Query inlined external tables and manage in-memory external tables
Create and use polymorphic table functions
- Describing Sharding Enhancements
Understand support for PDBs as shards
Describe Oracle GoldenGate enhancements for Oracle Sharding support
Describe improved multi-shard query enhancements
Query system objects across shards
Describe the user-defined sharding method
