1Z0-060: Upgrade to Oracle Database 12c


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