Oracle Database Administration II Exam Number: 1Z0-083




Oracle Database Administration II Exam Number: 1Z0-083


Creating CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1

  • Configure and create a CDB

  • Create a new PDB from the CDB seed

  • Explore the structure of PDBs

Manage CDBs and PDBs - Oracle Database: Managing Multitenant Architecture Ed 1

  • Manage PDB service names and connections

  • Manage startup, shutdown and availability of CDBs and PDBs

  • Change the different modes and settings of PDBs

  • Evaluate the impact of parameter value changes

  • Performance management in CDBs and PDBs

  • Control CDB and PDB resource usage with the Oracle Resource Manager

Backup and Duplicate - Oracle Database: Managing Multitenant Architecture Ed 1

  • Perform Backup and Recover CDBs and PDBs

  • Duplicate an active PDB

  • Duplicate a Database

Upgrading and Transporting CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1

  • Upgrade an Oracle Database

  • Transport Data

Manage Application PDBs - Oracle Database: Managing Multitenant Architecture Ed 1

  • Explain the purpose of application root and application seed

  • Define and create application PDBs

  • Install, upgrade and Patch applications

  • Create and administer Application PDBS

  • Clone PDBs and Application containers

  • Plug and unplug operations with PDBs and application containers

  • Comparing Local Undo Mode and Shared Undo Mode

Manage Security in Multitenant databases - Oracle Database: Managing Multitenant Architecture Ed 1

  • Manage Security in Multitenant databases

  • Manage PDB lockdown profiles

  • Audit Users in CDBs and PDBs

  • Manage other types of policies in application containers

Recovery and Flashback - Oracle Database: Managing Multitenant Architecture Ed 1

  • Restore and Recovering Databases with RMAN

  • Perform CDB and PDB flashback






Backup Strategies and Terminology - Oracle Database: Backup and Recovery Workshop

  • Perform Full and Incremental Backups and Recoveries

  • Compress and Encrypt RMAN Backups

  • Use a media manager

  • Create multi-section backups of very large files

  • Create duplexed backup sets

  • Create archival backups

  • Backup of recovery files

  • Backup non database files

  • Back up ASM meta data


Restore and Recovery Concepts - Oracle Database: Backup and Recovery Workshop

  • Employ the best Oracle Database recovery technology for your failure situation

  • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry


Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop

  • Configure your Database to support Flashback

  • Perform flashback operations


Duplicating a Database - Oracle Database: Backup and Recovery Workshop

  • Duplicate Databases

Configuring and Using RMAN - Oracle Database: Backup and Recovery Workshop

  • Configure RMAN and the Database for Recoverability

  • Configureand Using an RMAN recovery catalog

Diagnosing Failures - Oracle Database: Backup and Recovery Workshop

  • Detect and repair database and database block corruption

  • Diagnosing Database Issues

Performing Recovery - Oracle Database: Backup and Recovery Workshop

  • Restore and Recovering Databases with RMAN

  • Perform Non RMAN database recovery

Transporting Data - Oracle Database: Backup and Recovery Workshop

  • Transport Data

RMAN Troubleshooting and Tuning - Oracle Database: Backup and Recovery Workshop

  • Interpret the RMAN message output

  • Diagnose RMAN performance issues

Install Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Install Grid Infrastructure for a Standalone server

  • Install Oracle Database software


Patching Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Patch Grid Infrastructure and Oracle Database


Upgrading to Oracle Grid Infrastructure - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Upgrade Oracle Grid Infrastructure


Oracle Database 18c: New Features - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Image and RPM based Database Installation

Creating an Oracle Database by using DBCA - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Create, Delete and Configure Databases using DBCA

Oracle Restart - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Configure and use Oracle Restart to manage components

Upgrade the Oracle Database - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Plan for Upgrading an Oracle Database

  • Upgrade an Oracle Database

  • Perform Post-Upgrade tasks

Install Grid Infrastructure for a Standalone server - Oracle Database: Deploy, Patch and Upgrade Workshop

  • Rapid Home Provisioning

Using General Overall Database Enhancements - Oracle Database 19c: New Features for Administrators

  • Install Oracle Database software

  • Create, Delete and Configure Databases using DBCA

  • Creating CDBs and Regular PDBs

  • Use Miscellaneaous 19c New Features

Using Availability Enhancements - Oracle Database 19c: New Features for Administrators

  • Use an RMAN recovery catalog

  • Use Flashback Database

Using Diagnosibility Enhancements - Oracle Database 19c: New Features for Administrators

  • Use new Diagnoseability Features

Monitoring and Tuning Database Performance - Oracle Database: Administration Workshop

  • Managing Memory Components

  • Understanding The Automatic Workload Repository (AWR)

  • Understanding The Advisory Framework

  • Monitoring Wait Events, Sessions, and Services

  • Managing Metric Thresholds and Alerts

  • Understanding and Using The Performance Tuning Methodology

  • Performing Performance Planning

  • Understanding The Automatic Database Diagnostic Monitor (ADDM)

Tuning SQL Statements - Oracle Database: Administration Workshop

  • Understanding The Oracle Optimizer

  • Using The SQL Tuning Advisor

  • Managing Optimizer Statistics

  • Using The SQL Access Advisor

  • Understanding The SQL Tuning Process

Oracle Database Administration II Exam Number: 1Z0-083

Url: View Details

What you will learn
  • Oracle Database

Rating: 4.35

Level: Expert Level

Duration: 160 questions

Instructor: IT Exams


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of coursescompany.com.


© 2021 coursescompany.com. All rights reserved.
View Sitemap