1. Home
  2. Oracle
  3. 1Z0-060 Exam Syllabus

Oracle 1Z0-060 Exam Syllabus

Oracle 1Z0-060 Exam

Upgrade to Oracle Database 12c

Total Questions: 209

What is Included in the Oracle 1Z0-060 Exam?

Authentic information about the syllabus and an effective study guide is essential to go through the Oracle 1Z0-060 exam in the first attempt. The study guide of Study4Exam provides you with comprehensive information about the syllabus of the Oracle 1Z0-060 exam. You should get this information at the start of your preparation because it helps you make an effective study plan. We have designed this Oracle Oracle Database certification exam preparation guide to give the exam overview, practice questions, practice test, prerequisites, and information about exam topics that help to go through the Oracle Upgrade to Oracle Database 12c (2021) exam. We recommend you to the preparation material mentioned in this study guide to cover the entire Oracle 1Z0-060 syllabus. Study4Exam offers 3 formats of Oracle 1Z0-060 exam preparation material. Each format provides new practice questions in PDF format, web-based and desktop practice exams to get passing marks in the first attempt.

Oracle 1Z0-060 Exam Overview :

Exam Name Upgrade to Oracle Database 12c
Exam Code 1Z0-060
Actual Exam Duration 116 minutes
Expected no. of Questions in Actual Exam 85
Exam Registration Price $250
Official Information https://education.oracle.com/upgrade-to-oracle-database-12c/pexam_1Z0-060
See Expected Questions Oracle 1Z0-060 Expected Questions in Actual Exam
Take Self-Assessment Use Oracle 1Z0-060 Practice Test to Assess your preparation - Save Time and Reduce Chances of Failure

Oracle 1Z0-060 Exam Topics :

Section Weight Objectives
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 a non-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
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
  •     Relocate SYSAUX occupants
  •     Create a default permanent tablespace
  •     Use the Redo Logfile Size Advisor
  •     Use Secure File LOBs
  •     Use Direct NFS
Performance Management
  •     Design the database layout for optimal performance
  •     Monitor performace
  •     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 and diskgroups
  •     Manage ASM instance
  •     Manage VLDB
  •     Implement Space Management
Security
  •     Develop and implement a security policy
  •     Configure and manage auditing
  •     Create the password file
  •     Implement column and tablespace encryption

Updates in the Oracle 1Z0-060 Exam Syllabus:

Oracle 1Z0-060 exam questions and practice test are the best ways to get fully prepared. Study4exam's trusted preparation material consists of both practice questions and practice test. To pass the actual Oracle Database 1Z0-060 exam on the first attempt, you need to put in hard work on these Oracle 1Z0-060 questions that provide updated information about the entire exam syllabus. Besides studying actual questions, you should take the Oracle 1Z0-060 practice test for self-assessment and actual exam simulation. Revise actual exam questions and remove your mistakes with the Upgrade to Oracle Database 12c 1Z0-060 exam practice test. Online and windows-based formats of the 1Z0-060 exam practice test are available for self-assessment.

 

1Z0-060 Exam Details

Free 1Z0-060 Questions