Oracle Database Administration II (1Z0-083) Practice Exam

Oracle Database Administration II (1Z0-083) Practice Exam

The Oracle Database Administration II (1Z0-083) certification exam validates advanced proficiency in configuring, managing, and maintaining Oracle Database environments up to version 19c. It confirms a candidate’s ability to perform complex administration tasks such as installation, upgrades, patching, performance tuning, and security management. Achieving this certification highlights expertise in ensuring the reliability, efficiency, and security of enterprise-grade Oracle databases.

Who Should Take This Exam?

• Advance their careers: Validate their skills and knowledge in advanced Oracle database administration.
• Demonstrate expertise in Oracle 19c: Showcase their proficiency in managing the latest version of the Oracle Database.
• Specialize in complex database administration: Gain a deeper understanding of tasks like multi-tenant architecture, performance tuning, and database security.

Prerequisites

While there are no formal prerequisites, possessing the following is recommended:

• Experience with Oracle Database Administration: Prior experience administering Oracle databases, potentially including the Oracle Database Administration I (1Z0-051) certification.
• SQL Programming Skills: A solid understanding of SQL for querying and manipulating data within Oracle databases.
• Familiarity with Oracle 19c Features: Basic knowledge of new features and functionalities introduced in Oracle Database 19c.

Roles and Responsibilities 

With a 1Z0-083 certification, you might be qualified for roles such as:

• Senior Database Administrator: Taking on advanced database administration tasks, including performance optimization and security configuration.
• Oracle Database Architect: Participating in database design, deployment, and maintenance activities.
• Cloud Database Administrator (Oracle Focus): Managing Oracle databases deployed on cloud platforms using your Oracle database administration expertise.
• Database Security Specialist (Oracle): Specializing in securing Oracle database environments with advanced security features.

Exam Details 

• Format: Multiple Choice
• Duration: 120 Minutes
• Number of Questions: 68
• Passing Score: 57%

Course Outline

The exam covers the following topics:

1. 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

2. 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

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

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

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

• Upgrade an Oracle Database
• Transport Data

5. 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

6. 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

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

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

8. 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

9. 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

10. Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop

• Configure  your Database  to support Flashback
• Perform flashback operations

11. Duplicating a Database - Oracle Database: Backup and Recovery Workshop

• Duplicate Databases

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

• Configure RMAN and the Database for Recoverability
• Configureand Using an RMAN recovery catalog

13. Diagnosing Failures - Oracle Database: Backup and Recovery Workshop

• Detect and repair database and database block corruption
• Diagnosing Database Issues

14. Performing Recovery - Oracle Database: Backup and Recovery Workshop

• Restore and Recovering Databases with RMAN
• Perform Non RMAN database recovery

15. Transporting Data - Oracle Database: Backup and Recovery Workshop

• Transport Data

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

• Interpret the RMAN message output
• Diagnose RMAN performance issues

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

• Install Grid Infrastructure for a Standalone server
• Install Oracle Database software

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

• Patch Grid Infrastructure and Oracle Database

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

• Upgrade Oracle Grid Infrastructure

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

• Image and RPM based Database Installation

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

• Create, Delete and Configure Databases using DBCA

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

• Configure and use Oracle Restart to manage components

23. 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

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

• Rapid Home Provisioning

25. 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

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

• Use an RMAN recovery catalog
• Use Flashback Database

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

• Use new Diagnoseability Features

28. 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)

29. 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