Oracle 12c Administration Exam Objective

Session 01: Exploring the Oracle Database Architecture

Session 02: Oracle Database Instance

Session 03: Administering User Security

Session 04: Create and manage tablespaces

Session 05: Managing Data Concurrency

Session 06: Backup and Recovery Concepts

Session 07: Performing Database Backups

Session 08: Moving Data

Session 09: Managing Performance: SQL Tuning

Session 10: Creating an Oracle Database Using DBCA

Session 11: Introduction to DBAAS

Session 12: Oracle Database Management Tools

Session 13: Configuring the Oracle Network Environment

Session 14: Managing Database Storage Structures

Session 15: Managing Undo Data

Session 16: Implementing Oracle Database Auditing

Session 17: Backup and Recovery Configuration

Session 18: Performing Database Recovery

Session 19: Performing Database Maintenance

Session 20: Automating Tasks by Using Oracle Scheduler

Session 21: Upgrading Oracle Database Software

Detailed Syllabus:

Session 01: Exploring the Oracle Database Architecture

List the architectural components of Oracle Database
Explain the memory structures
Describe the background processes

Session 02: Oracle Database Instance

Understand initialization parameter files
Start up and shut down an Oracle database instance
View the alert log and access dynamic performance views

Session 03: Administering User Security

Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles

Session 04: Create and manage tablespaces

Explain how Oracle database server automatically manages space
Save space by using compression
Use the Segment Advisor
Reclaim wasted space from tables and indexes by using the segment shrink functionality

Session 05: Managing Data Concurrency

Describe the locking mechanism and how Oracle manages data concurrency
Monitor and resolve locking conflicts

Session 06: Backup and Recovery Concepts

Identify the importance of checkpoints, redo log files, and archive log files

Session 07: Performing Database Backups

Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups

Session 08: Moving Data

Describe ways to move data
Use SQL*Loader to load data from a non-Oracle database
Use external tables to move data via platform-independent files
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases

Session 09: Managing Performance: SQL Tuning

Use the SQL Tuning advisor

Session 10: Creating an Oracle Database Using DBCA

Generate database creation scripts by using DBCA
Manage database design templates by using DBCA

Session 11: Introduction to DBAAS

Recognize the difference between a DBaaS Instance and a Database Instance
Navigate with My Services Dashboard
User authentication and roles
Generate a Secure Shell (SSH) Public/Private Key Pair

Session 12: Oracle Database Management Tools

Use database management tools

Session 13: Configuring the Oracle Network Environment

Configure Oracle Net Services
Use tools for configuring and managing the Oracle network
Configure client-side network
Configure communication between databases

Session 14: Managing Database Storage Structures

Describe the storage of table row data in blocks
Create and manage tablespaces

Session 15: Managing Undo Data

Explain DML and undo data generation
Monitor and administer undo data
Describe the difference between undo data and redo data
Configure undo retention

Session 16: Implementing Oracle Database Auditing

Enable standard database auditing and unified auditing

Session 17: Backup and Recovery Configuration

Configure the fast recovery area
Configure ARCHIVELOG mode

Session 18: Performing Database Recovery

Determine the need for performing recovery
Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file

Session 19: Performing Database Maintenance

Use server-generated alerts

Session 20: Automating Tasks by Using Oracle Scheduler

Use Oracle Scheduler to simplify management tasks
Use job chains to perform a series of related tasks
Use Scheduler jobs on remote systems
Use advanced Scheduler features to prioritize jobs

Session 21: Upgrading Oracle Database Software

Describe data migration methods
Describe the upgrade process

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.