Oracle Database 12c New Features

New Features of Oracle Database 12c 
 
Enterprise Manager and Other Tools
Use EM Express
Use OUI, DBCA for installation and configuration

Basics of Multitenant Container Database (CDB)
Identify the benefits of the multitenant container database
Explain root and multitenant architecture

Configuring and Creating CDBs and PDBs
Create and configure a CDB
Create and configure a PDB
Migrate a non-CDB to a PDB database

Managing CDBs and PDBs
Establish connection to a CDB/PDB
Start up and shut down a CDB/PDB
Change instance parameters for 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

Backup, Recovery and Flashback for a CDB/PDB
Perform backup of CDB and PDB
Perform recovery of CDB and PDB
Perform Flashback for a CDB

Information Lifecycle Management and Storage Enhancements
Use ILM features
Perform tracking and automated data placement
Use Online Move Datafile

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

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

Privileges
Use administrative privileges
Create, enable and use privilege analysis

Oracle Data Redaction
Use and manage Oracle Data Redaction policies

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

Real-Time Database Operation Monitoring
Implement real-time database operation monitoring

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

Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics
Perform emergency monitoring and real-time ADDM
Generate ADDM Compare Period
Diagnose performance issues using ASH enhancements

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

Index and Table Enhancements
Use Index enhancements
Use Table enhancements
Use Online operation enhancements

ADR and Network Enhancements
Explain ADR enhancements

Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
Use Oracle Data Pump enhancements
Use SQL*Loader and External table enhancements

Partitioning Enhancements
Explain Partitioning enhancements
Explain Index enhancements for partitioned tables

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

Key DBA Skills 

Core Administration
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  

Performance Management
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

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

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