Oracle Database Administration II
1z0-083
Money Back Guarantee
98% Success Rate
Real Questions
1
Managing Multitenant Architecture 35%
1.1
Creating CDBs and Regular PDBs
3 subtopics1.1.1Configure and create a CDB
1.1.2Create a new PDB from the CDB seed
1.1.3Explore the structure of PDBs
Learning Objectives
- Configure and create container databases
- Create pluggable databases from seed template
- Understand PDB architecture and structure
1.2
Manage CDBs and PDBs
6 subtopics1.2.1Manage PDB service names and connections
1.2.2Manage startup, shutdown and availability of CDBs and PDBs
1.2.3Change the different modes and settings of PDBs
1.2.4Evaluate the impact of parameter value changes
1.2.5Performance management in CDBs and PDBs
1.2.6Control CDB and PDB resource usage with Oracle Resource Manager
Learning Objectives
- Manage PDB lifecycle operations
- Configure and control resource allocation
- Monitor and tune multitenant performance
1.3
Manage Application PDBs
7 subtopics1.3.1Explain the purpose of application root and application seed
1.3.2Define and create application PDBs
1.3.3Install, upgrade and Patch applications
1.3.4Create and administer Application PDBs
1.3.5Clone PDBs and Application containers
1.3.6Plug and unplug operations with PDBs and application containers
1.3.7Comparing Local Undo Mode and Shared Undo Mode
Learning Objectives
- Understand application container architecture
- Manage application PDB lifecycle
- Implement application versioning and patching
1.4
Backup and Duplicate
3 subtopics1.4.1Perform Backup and Recover CDBs and PDBs
1.4.2Duplicate an active PDB
1.4.3Duplicate a Database
Learning Objectives
- Implement backup strategies for multitenant
- Perform PDB and CDB recovery
- Execute database duplication
1.5
Recovery and Flashback
2 subtopics1.5.1Restore and Recovering Databases with RMAN
1.5.2Perform CDB and PDB flashback
Learning Objectives
- Perform database recovery with RMAN
- Implement flashback operations
- Configure flashback database
1.6
Upgrading and Transporting CDBs and Regular PDBs
2 subtopics1.6.1Upgrade an Oracle Database
1.6.2Transport Data
Learning Objectives
- Plan and execute database upgrades
- Transport data between databases
- Manage upgrade procedures
1.7
Manage Security in Multitenant databases
4 subtopics1.7.1Manage Security in Multitenant databases
1.7.2Manage PDB lockdown profiles
1.7.3Audit Users in CDBs and PDBs
1.7.4Manage other types of policies in application containers
Learning Objectives
- Implement security in multitenant environments
- Configure lockdown profiles
- Manage auditing policies
Domain Hands-on Skills
Create and manage CDBs and PDBsConfigure Resource Manager for multitenantImplement application containersPerform plug/unplug operations
Common Mistakes to Avoid
- Not understanding CDB vs PDB architecture
- Incorrect resource allocation
- Improper security configuration
2
Backup and Recovery 30%
3
Database Deployment, Patching, and Upgrading 20%
4