Please enable JavaScript.
Coggle requires JavaScript to display documents.
Exam Prep IZ0-074 : Upgrade Oracle DBA 11g or 12c to 12cR2 (Database Cloud…
Exam Prep IZ0-074 : Upgrade Oracle DBA 11g or 12c to 12cR2
Administration
Using CDBs and Application Containers
Creating Different Types of PDBs
Using Diagnostic Enhancements
Manageability
Performance Tuning
Tuning SQL Statements
Describe the Optimizer Statistics Advisor
Use SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
Triggers with DMLs
Usage of SYSDATE
Rows to fetch
New SQL JOIN processing
Continuous Adaptive Query Plans
Use Adaptive Execution Plans
Use enhanced features of statistics gathering
Performing In Memory Column Store
Explain how to deploy the in-memory column store in a database (static and dynamic)
Managing Performance in PDBs and CDBs
Manage memory allocation between PDBs
Manage resources allocation between PDBs with Resource Manager Performance Profile
Security
Managing Users and Users Access to Data in a Multitenant Environment
Users
DPB LockDown Profiles
Using Data Redaction
Create and reuse redaction formats from library
Performing Unified Auditing
Using Data Encryption
Using TSPD policies with Auditing and Column Encryption
Database Cloud Service
Describe the Oracle Public Cloud Services
Describe the Oracle Database Cloud Services
Access Console
Console Description
Create a database deployment
Doc Link
Explain database deployment backup and recovery automatic procedures
Monitor database deployment using DBaaS Monitor console
Describe the differences between database deployments and on-premises databases
Migrate on-premises database to Oracle Database Public Cloud Services
Development
Using SQL Enhancements
Describe the SQL identifiers new lengths
Describe the new VALIDATE_CONVERSION
Describe the new SQLcl
SQL Developer
Command-Line Quick Reference
Storage
Administrating Storage
Objectives:
Administer ASM Instances, ASM Diskgroups and ASM disk
Using Information Lifecycle Management and Storage Enhancements
Use ILM features
HCC Compression with ADO Row-Level
Table Compression
Automatic Data Optimization Support for In-Memory Column Store
Heat Map and Automatic Data Optimization
Backup and recovery
Creating and Managing backup and recovery catalog
Recovering a database
Recovering and Flashing back CDBs and PDBs
Data Warehousing and VLDB
Transporting a tablespace
Using Oracle Data Pump, SQL*Loader and External
Applying Different Types of Partitioning
Interval-Reference Partitioning
Range Partitioning for Hash Clusters
Automatic List Partitioning
Multi-column List Partitioning
Converting a Non-Partitioned Table to a Partitioned Table