Login     Signup
   info@zetlantechnologies.com        +91-8680961847

  /   Oracle Technical Certification   /   ODA - II


Exam 1Z0-083: Oracle Database Administration II


Exam Code Delivery format Duration No of Questions Passing Score
1Z0-083 Proctored Online Multiple Choice 120 Minutes 68 57%

Exam Overview

An Oracle Database Administration 2019 Certified Professional has proven theoretical understanding of and the practical skills required to configure and manage Oracle Databases up to and including Oracle 19c. Passing this second exam in a two exam path proves your skills in: installation, upgrades, patching, SQL programming skills, database and network administration and backup and recovery. This person also demonstrates fluency with some advanced skills such as multi-tenant, SQL performance monitoring and problem determination.


Course Details

1. Creating CDBs and Regular PDBs

  • Configure and create a CDB
  • Create a new PDB from the CDB seed
  • Explore the structure of PDBs

  • 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

  • Perform Backup and Recover CDBs and PDBs
  • Duplicate an active PDB
  • Duplicate a Database

  • Upgrade an Oracle Database
  • Transport Data

  • 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
  • Manage PDB lockdown profiles
  • Audit Users in CDBs and PDBs
  • Manage other types of policies in application containers

  • Restore and Recovering Databases with RMAN
  • Perform CDB and PDB flashback

  • 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

  • Employ the best Oracle Database recovery technology for your failure situation
  • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery

  • Configure your Database to support Flashback
  • Perform flashback operations

  • Duplicate Databases
  • Configure RMAN and the Database for Recoverability
  • Configure and Using an RMAN recovery catalog
  • Detect and repair database and database block corruption
  • Diagnosing Database Issues
  • Restore and Recovering Databases with RMAN
  • Perform Non RMAN database recovery
  • Transport Data
  • Interpret the RMAN message output
  • Diagnose RMAN performance issues

  • Install Grid Infrastructure for a Standalone server
  • Install Oracle Database software
  • Patch Grid Infrastructure and Oracle Database
  • Upgrade Oracle Grid Infrastructure
  • Image and RPM based Database Installation
  • Create, Delete and Configure Databases using DBCA
  • Configure and use Oracle Restart to manage components

  • Plan for Upgrading an Oracle Database
  • Upgrade an Oracle Database
  • Perform Post-Upgrade tasks
  • Rapid Home Provisioning
  • Install Oracle Database software
  • Create, Delete and Configure Databases using DBCA
  • Creating CDBs and Regular PDBs
  • Use Miscellaneaous 19c New Features
  • Use an RMAN recovery catalog
  • Use Flashback Database
  • Use new Diagnosability Features

  • 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)

  • Understanding The Oracle Optimizer
  • Using The SQL Tuning Advisor
  • Managing Optimizer Statistics
  • Using The SQL Access Advisor
  • Understanding The SQL Tuning Process


Fees Structure : 15500 INR / 185 USD
Total No of Class : 80 Video Class
Class Duration : 59:30 Working Hours
Download Feature : Download Avalable
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure       Buy Now       Sample Demo

Fees Structure : 30000 INR / 355 USD
Class Duration : 60 Days
Class Recording : Live Class Recording available
Class Time : Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure       Pay Online

Information Technologies

Why People Like us!

For over a decade, we have been on a mission: helping everyone grow up in IT Industry. Today, we are asking that you join us.

Read More

More Info

About Us Contact Us Privacy Policy Terms & Condition Refund Policy FAQs & Help

Account

My Account Course Details Shopping Cart Wishlist Order History Payment Details

Contact

Address: Chennai, Tamilnadu, India

Email: info@zetlantechnologies.com

Phone: +91 8680961847

Payment Accepted

Zetlan Technologies, All right reserved.