General Database and Network Administration
Create and manage pluggable databases
Administer users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Administer database configuration files
Configure shared server
Manage network file directories
Manage Database Availability
Install the EM Cloud Control agent
Configure recovery catalog
Configure RMAN
Perform a full database backup
Configure and monitor Flashback Database
Manage database links
Oracle – Admin – 32 Managing a Distributed Database
https://docs.oracle.com/database/121/ADMIN/ds_admin.htm#ADMIN029
Manage a fast refreshable materialized view
Oracle – Data Warehousing and Business Intelligence – 7 Refreshing Materialized Views
Create a plug-in tablespace by using the transportable tablespace feature
Oracle – Database Administration – 15 Transporting Data
https://docs.oracle.com/database/121/ADMIN/transport.htm#ADMIN13721
Optimize star queries
https://docs.oracle.com/cd/E29633_01/CDMOG/GUID-A21256D6-7A93-4FBA-9688-053F6C5CF432.htm
Database Administration – Database SQL Tuning Guide – 5 Query Transformations
https://docs.oracle.com/database/121/TGSQL/tgsql_transform.htm#TGSQL9487
Configure parallel execution
VLDB and Partitioning Guide – 8 Using Parallel Execution
Apply a Patch
Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
Data Warehousing and Business Intelligence – Database VLDB and Partitioning Guide – 5 Managing and Maintaining Time-Based Information
https://docs.oracle.com/database/121/VLDBG/GUID-AC2B567F-14EF-4E7A-9992-076A2A820305.htm#VLDBG1283
Data Management
Manage additional buffer cache
Optimize space usage for the LOB data
Manage an encrypted tablespace
Manage schema data
Manage partitioned tables
Set up Fine-Grained Auditing
Configure the database to retrieve all previous versions of the table rows
Performance Management
Configure the Resource Manager
Tune SQL statements
Use real application testing
Manage SQL Plan baselines
Capture performance statistics
Tune an instance – Configure and manage result cache, Control CPU use for Oracle Instances, Configure and manage “In Memory” features
Manage extended statistics – https://blogs.oracle.com/optimizer/extended-statistics
Create and manage partitioned indexes
Data Guard
Administer a Data Guard environment
Create a physical standby database
Configure a standby database for testing – Snapshot standby
Configure a standby database to apply redo – LSN / Standby logs(current log file apply )
Configure a standby database to use for reporting – Logical Standby
Configure fast start failover
Manage DDL in a Data Guard environment
https://docs.oracle.com/database/121/SBYDB/manage_ls.htm#SBYDB00800
Grid Infrastructure
Install Oracle Grid Infrastructure
Create ASM Disk Groups
Create and manage ASM instances
Configure ASM Cloud File System (ACFS)
Administer Oracle Clusterware
Manage Flex Clusters and Flex ASM
Real Application Cluster Database
Install Oracle Database software
Create a Real Application Clusters (RAC) database
Configure Database Services
Administer Oracle RAC databases on one or more cluster nodes