Enhance your certification score. Even though you're working at a top company, you'll want to keep your certification score up. It's important for your job search, especially if you want to go for a higher level position. When you're looking for new jobs, people are going to be screening your resume a bit with certifications.

Understand the test structure and what to expect; then walk through each topic area, quiz yourself with practice questions and answers, and ensure you’re ready to take the certification.

Scenario based exam questions for Upgrade to Oracle Database 12c | 1Z0-060 Certification

Online practice exam to be completed in Specified Time Duration.

Practice tests are created by Subject Matter Experts. Your results are immediately available, while you stay focused on your exam results. Practice tests provides the answer to a test/questions you haven't already learned.

Exam Questions similar to actual Certification Exam.

Life time Access to practice tests to try as many times until you master the subject. You have access to practice test answers 24 hours a day, 365 days a year. If you're not satisfied, you can easily return to the practice test to make corrections.

The practice test have been designed carefully by maintaining the exam structure , syllabus, topic weights , cut score and time duration same as actual certification exam.

The aim of the practice exam is to allow the candidate to identify the risks related to a exam topics and be able to recognise them when analysing a real practice scenario.

Applicants will need to make sure that they are able to complete the practice examination in its entirety and pass all the multiple choice tests in general nature.

Official Exam Details:

Exam Name : Upgrade to Oracle Database 12c

Exam Code :1Z0-060

Exam Level : Associate

Duration : 120 mins

Number of Questions :80

Passing Score : Section 1 = 64%; Section 2 = 65%

Total Questions to check your knowledge: 150 (Actual exam contains 80 questions)

New Features of Oracle Database 12c

Enterprise Manager and Other Tools

• 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

Auditing

• 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

Security

• 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

Privileges

• 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

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

Storage

• Manage database structures

• Administer ASM

• Manage ASM disks and diskgroups

• Manage ASM instance

• Manage VLDB

• Implement Space Management