Skillset1：General Databaseand Network Administration
General Database and Network Administration
Create and manage pluggable databases.
Create and manage users, roles, and privileges.
Configure the network environment to allow connections to multiple databases.
Create and manage database configurationfiles.
Skillset2: Managing Database Availability
Install the EM Cloud Control agent
Configure recovery catalog.
Configure RMAN.
Perform a full database backup.
Configure and monitor Flashback Database.
Skillset3:Data Warehouse Manageme
Create a database link.
Create a fast refreshable materializedview.
Create a plug-in tablespace by using the transportable tablespace feature.
Optimize star queries.
Configure parallel execution.
Apply a Patch
Configure Automatic Data Optimization,In-Row Archiving, and Temporal Validity
Skillset4:Data Management
Create an additional buffer cache.
Optimize space usage for the LOB data.
Create an encrypted tablespace.
Manage schema data.
Create partitioned tables.
Set up Fine-Grained Auditing.
Configure the database to retrieve allprevious versions of the table rows.
Skillset5: Performance Management
Configure the Resource Manager.
Tune SQL statements.
Perform real application testing.
Create SQL Plan baselines.
Capture performance statistics.
Tune an instance
Skillset6: Data Guard
Administer a Data Guard environment.
Create a physical standby database.
Configure a standby database for testing.
Configure a standby database to apply redo.
Configure a standby database to use forreporting.
Configure fast start failover.
Skillset7: Grid Infrastructure
Install Oracle Grid Infrastructure.
Create ASM Disk Groups.
Create and manage ASM instances.
Configure ASM Cloud File System (ACFS).
Administer Oracle Clusterware.
Skillset8:Real Application Cluster Database
Install Oracle Database software
Create a Real Application Clusters (RAC)database
Configure Database Services.
by:cuug
