Keep Calm and Study On - Unlock Your Success - Use #TOGETHER for 30% discount at Checkout

Upgrade to Oracle Database 12c (1Z0-060) Practice Exam

Upgrade to Oracle Database 12c (1Z0-060) 

About Upgrade to Oracle Database 12c (1Z0-060)

1Z0-060 exam is for candidate having an understanding of Configuring and Creating CDBs and PDBs, Information Lifecycle Management and Storage Enhancements, Auditing, Resource Manager and Other Performance Enhancements and Basics of Multitenant Container Database (CDB).

Course Structure

The Upgrade to Oracle Database 12c (1Z0-060) Exam covers the following topics -

New Features of Oracle Database 12c

Use EM Express

Use OUI, DBCA for installation and configuration

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 Tablespaces, Common and Local Users, Privileges and Roles

Manage tablespaces in a CDB/PDB

Manage users and privileges for CDB/PDB

Information Lifecycle Management and Storage Enhancements

Use ILM features

Perform tracking and automated data placement

Move a data file online


Enable and configure Unified Audit Data Trail

Create and enable audit policies

Oracle Data Redaction

Use and manage Oracle Data Redaction policies

Real-Time Database Operation Monitoring

Implement real-time database operation monitoring

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

Index and Table Enhancements

Use Index enhancements

Use Table enhancements

Use Online operation enhancements

Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements

Use Oracle Data Pump enhancements

Use SQL*Loader and External table enhancements

SQL Enhancements

Use Oracle Database Migration Assistant for Unicode

Use Row limiting clause, and secure file LOBs enhancements

Configure extended datatypes

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


Develop and implement a security policy

Configure and manage auditing

Create the password file

Implement column and tablespace encryption

Basics of Multitenant Container Database (CDB)

Identify the benefits of the multitenant container database

Explain root and multitenant architecture

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

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

In-Database Archiving and Valid-Time Temporal

Differentiate between ILM and Valid-Time Temporal

Set and use Valid Time Temporal

Use In-Database archiving


Use administrative privileges

Create, enable and use privilege analysis

RMAN and Flashback Data Archive

Use RMAN enhancements

Implement the new features in Flashback Data Archive

SQL Tuning

Use Adaptive Execution Plans

Use enhanced features of statistics gathering

Use Adaptive SQL Plan Management

Resource Manager and Other Performance Enhancements

Use Resource Manager for a CDB and PDB

Explain Multi-process Multi-threaded Oracle architecture

Use Flash Cache

ADR and Network Enhancements

Explain ADR enhancements

Partitioning Enhancements

Explain Partitioning enhancements

Explain Index enhancements for partitioned tables

Key DBA Skills

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


Manage database structures

Administer ASM

Manage ASM disks and diskgroups

Manage ASM instance

Manage VLDB

Implement Space Management

Exam Pattern 

  • Exam Name: Upgrade to Oracle Database 12c
  • Exam Code: 1Z0-060
  • Number of Questions: 80
  • Length of Time:  120 minutes
  • Exam Fee $245 USD 
  • Exam Language: English

What do we offer?

  • Full-Length Mock Test with unique questions in each test set
  • Practice objective questions with section-wise scores
  • An in-depth and exhaustive explanation for every question
  • Reliable exam reports evaluating strengths and weaknesses
  • Latest Questions with an updated version
  • Tips & Tricks to crack the test
  • Unlimited access

What are our Practice Exams?

  • Practice exams have been designed by professionals and domain experts that simulate real time exam scenario.
  • Practice exam questions have been created on the basis of content outlined in the official documentation.
  • Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
  • Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
  • You can also create your own practice exam based on your choice and preference 

100% Assured Test Pass Guarantee

We have built the TestPrepTraining Practice exams with 100% Unconditional and assured Test Pass Guarantee! 

If you are not able to clear the exam, you can ask for a 100% refund.

Tags: Upgrade to Oracle Database 12c (1Z0-060) Exam Dumps, Upgrade to Oracle Database 12c (1Z0-060) Exam Questions, Upgrade to Oracle Database 12c (1Z0-060) Free Test