ADR and Network Enhancements
Explain ADR Enhancements
Network Enhancements
Auditing
Create and enable audit policies
Enable and configure Unified Audit Data Trail
Enable Unified Auditing
Backup, Recovery and Flashback for a CDB/PDB
Perform backup of CDB and PDB
Perform recovery of CDB and PDB
Basics of Multitenant Container Database (CDB)
Explain root and multitenant architecture
Identify the benefits of the multitenant container database
Configuring and Creating CDBs and PDBs
Create and configure a CDB
Create and configure a PDB
Migrate a non-CDB to a PDB database
Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics
Diagnose performance issues using ASH enhancements
Generate ADDM Compare Period
Perform emergency monitoring and real-time ADDM
Enterprise Manager and Other Tools
Use EM Express
Use OUI, DBCA for installation and configuration
In-Database Archiving and Valid-Time Temporal
Differentiate between ILM and Valid-Time Temporal
Set and use Valid Time Temporal
Use In-Database archiving
Index and Table Enhancements
Use Index enhancements
Use Online operation enhancements
Use Table enhancements
Information Lifecycle Management and Storage Enhancements
Move a data file online
Perform tracking and automated data placement
Use ILM features
Managing CDBs and PDBs
Change instance parameters for a CDB/PDB
Establish connection to a CDB/PDB
Start up and shut down a CDB/PDB
Managing Tablespaces, Common and Local Users, Privileges and Roles
Manage tablespaces in a CDB/PDB
Manage users and privileges for CDB/PDB
Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
Use Oracle Data Pump enhancements
Use SQL*Loader and External table enhancements
Oracle Data Redaction
Partitioning Enhancements
Explain Index enhancements for partitioned tables
Explain Partitioning enhancements
Privileges
Create, enable and use privilege analysis
Use administrative privileges
Real-Time Database Operation Monitoring
Resource Manager and Other Performance Enhancements
Explain Multi-process Multi-threaded Oracle architecture
Use Flash Cache
Use Resource Manager for a CDB and PDB
RMAN and Flashback Data Archive
Implement the new features in Flashback Data Archive
Use RMAN enhancements
SQL Enhancements
Configure extended datatypes
Use Oracle Database Migration Assistant for Unicode
Use Row limiting clause, and secure file LOBs enhancements
SQL Tuning
Use Adaptive Execution Plans
Use Adaptive SQL Plan Management
Use enhanced features of statistics gathering