• Use EM Express
• Use OUI, DBCA for installation and configuration

• Identify the benefits of the multitenant container database
• Explain root and multitenant architecture

• Create and configure a CDB
• Create and configure a PDB
• Migrate a non-CDB to a PDB database

• Establish connection to a CDB/PDB
• Start up and shut down a CDB/PDB
• Change instance parameters for a CDB/PDB

• Manage tablespaces in a CDB/PDB
• Manage users and privileges for CDB/PDB

• Perform backup of CDB and PDB
• Perform recovery of CDB and PDB
• Perform Flashback for a CDB

• Use ILM features
• Perform tracking and automated data placement
• Use Online Move Datafile

• Differentiate between IL and Valid-Time Temporal
• Set and use Valid Time Temporal
• Use In-Database archiving

• Enable and configure Unified Audit Data Trail
• Create and enable audit policies

• Use administrative privileges
• Create, enable and use privilege analysis

• Use and manage Oracle Data Redaction policies

RMAN and Flashback Data Archive

• Use RMAN enhancements
• Implement the new features in Flashback Data Archive

• Implement real-time database operation monitoring

• Use Adaptive Execution Plans
• Use enhanced features of statistics gathering
• Use Automatic SQL Plan Management

• Perform emergency monitoring and real-time ADDM
• Generate ADDM Compare Period
• Diagnose performance issues using ASH enhancements

• Use Resource Manager for a CDB and PDB
• Explain Multi-process Multi-threaded Oracle architecture
• Use Flash Cache

• Use Index enhancements
• Use Table enhancements
• Use Online operation enhancements

• Explain ADR enhancements

• Use Oracle Data Pump enhancements
• Use SQL*Loader and External table enhancements

• Explain Partitioning enhancements
• Explain Index enhancements for partitioned tables

• Use Oracle Database Migration Assistant for Unicode
• Use Row limiting clause, and secure file LOBs enhancements
• Configure extended datatypes

• Explain the fundamentals of DB architecture
• Install and configure a database
• Configure server and client network for a database
• Monitor database alerts
• Perform daily administration tasks
• Apply and review patches
• Back up and recover the database
• Troubleshoot network and database issues
• Detect and repair data failures with Data Recovery Advisor
• Implement Flashback Technology
• Load and Unload Data
• Miscellaneous
  • Relocate SYSAUX occupants
  • Create a default permanent tablespace
  • Use the Redo Logfile Size Advisor
  • Use Secure File LOBs
  • Use Direct NFS

• Design the database layout for optimal performance
• Monitor performace
• Manage memory
• Analyze and identify performance issues
• Perform real application testing
• Use Resource Manager to manage resources
• Implement Application Tuning

• Manage database structures
• Administer ASM
• Manage ASM disks and diskgroups
• Manage ASM instance
• Manage VLDB
• Implement Space Management

• Develop and implement a security policy
• Configure and manage auditing
• Create the password file
• Implement column and tablespace encryption