Full Name: Upgrade to Oracle Database 12c
Exam Code: 1Z0-060
Oracle 1Z0-060 Certification Details:
Exam Name
|
Upgrade to Oracle Database 12c
|
Exam Code
|
1Z0-060
|
Exam Product Version
|
Oracle Database 12c
|
Exam Price
|
USD $245 (Pricing may vary by country or by localized currency)
|
Duration
|
120 minutes
|
Number of Questions
|
80
|
Passing Score
|
Section 1 - 64% Section 2 - 65% |
Recommended Training
|
|
Format
|
Multiple Choice
|
Recommended Training
|
|
Recommended Practice
|
Oracle 1Z0-060 Syllabus Topics:
New Features of Oracle Database 12c | |
Enterprise Manager and Other Tools | - Use EM Express - Use OUI, DBCA for installation and configuration |
Basics of Multitenant Container Database (CDB) | - Identify the benefits of the multitenant container database - Explain root and multitenant architecture |
Configuring and Creating CDBs and PDBs | - Create and configure a CDB - Create and configure a PDB - Migrate anon-CDB to a PDB database |
Managing CDBs and PDBs | - Establish connection to a CDB/PDB - Start up and shut down a CDB/PDB - Change instance parameters for a CDB/PDB |
Managing Tablespaces, Common and Local Users, Privileges and Roles | - Manage tablespaces in a CDB/PDB - Manage users and privileges for CDB/PDB |
Backup, Recovery and Flashback for a CDB/PDB | - Perform backup of CDB and PDB - Perform recovery of CDB and PDB - Perform Flashback for a CDB |
Information Lifecycle Management and Storage Enhancements | - Use ILM features - Perform tracking and automated data placement - Move a data file online |
In-Database Archiving and Valid-Time Temporal | - Differentiate between ILM and Valid-Time Temporal - Set and use Valid Time Temporal - Use In-Database archiving |
Auditing | - Enable and configure Unified Audit Data Trail - Create and enable audit policies |
Privileges | - Use administrative privileges - Create, enable and use privilege analysis |
Oracle Data Redaction | - Use and manage Oracle Data Redaction policies |
RMAN and Flashback Data Archive | - Use RMAN enhancements - Implement the new features in Flashback Data Archive |
Real-Time Database Operation Monitoring | - Implement real-time database operation monitoring |
SQL Tuning | - Use Adaptive Execution Plans - Use enhanced features of statistics gathering - Use Adaptive SQL Plan Management |
Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics |
- Perform emergency monitoring and real-time ADDM - Generate ADDM Compare Period - Diagnose performance issues using ASH enhancements |
Resource Manager and Other Performance Enhancements | - Use Resource Manager for a CDB and PDB - Explain Multi-process Multi-threaded Oracle architecture - Use Flash Cache |
Index and Table Enhancements | - Use Index enhancements - Use Table enhancements - Use Online operation enhancements |
ADR and Network Enhancements | - Explain ADR enhancements |
Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements |
- Use Oracle Data Pump enhancements - Use SQL*Loader and External table enhancements |
Partitioning Enhancements | - Explain Partitioning enhancements - Explain Index enhancements for partitioned tables |
SQL Enhancements | - Use Oracle Database Migration Assistant for Unicode - Use Row limiting clause, and secure file LOBs enhancements - Configure extended datatypes |
Key DBA Skills | |
Core Administration | - Explain the fundamentals of DB architecture - Install and configure a database - Configure server and client network for a database - Monitor database alerts - Perform daily administration tasks - Apply and review patches - Back up and recover the database - Troubleshoot network and database issues - Detect and repair data failures with Data Recovery Advisor - Implement Flashback Technology - Load and Unload Data - Miscellaneous 1. Relocate SYSAUX occupants 2. Create a default permanent tablespace 3. Use the Redo Logfile Size Advisor 4. Use Secure File LOBs 5. Use Direct NFS |
Performance Management | - Design the database layout for optimal performance - Monitorperformace - Manage memory - Analyze and identify performance issues - Perform real application testing - Use Resource Manager to manage resources - Implement Application Tuning |
Storage | - Manage database structures - Administer ASM - Manage ASM disks anddiskgroups - Manage ASM instance - Manage VLDB - Implement Space Management |
Security | - Develop and implement a security policy - Configure and manageauditing - Create the password file - Implement column and tablespace encryption |
0 comments:
Post a Comment