1Z0-060 Real Exam Questions
Upgrade to Oracle Database 12c. Everything you need to prepare, practice, and pass.
232
Questions
7
Exam Domains
Included
Explanations
Ready to practice?
232+ questions with detailed explanations
Start NowFrom $49.99 USD · refund policy applies
Browse all 232 1Z0-060 questions
Certification Overview
This exam tests deep knowledge of Oracle Database 12c's architecture and features, emphasizing the upgrade path from earlier versions and practical implementation of 12c's innovations in security, performance, availability, and storage. Heavy focus on Multitenant features and understanding how 12c changes database design and administration approaches.
What This Certification Proves
This upgrade certification validates expertise in migrating to Oracle Database 12c and leveraging its new capabilities across availability, performance, security, manageability, and storage. It's essential for database professionals responsible for planning and executing database upgrades in enterprise environments.
Who Should Take This Exam
Oracle Database Administrators (DBAs) and senior database engineers with 5+ years of experience managing Oracle databases (11g or earlier versions). Professionals tasked with planning and executing upgrade projects in their organizations.
Topic Breakdown
7 domains covering 232 questions
| Domain | Questions | Weight |
|---|---|---|
| New Features For Performance | 49 | 21% |
| New Features For Database Infrastructure And Architecture | 45 | 19% |
| New Features For Availability | 35 | 15% |
| New Features For Manageability | 31 | 13% |
| New Features For Security | 27 | 12% |
| New Features For Storage | 25 | 11% |
| Upgrading To Oracle Database 12c | 20 | 9% |
Study Plans
Choose a study plan that matches your schedule and experience level
30 Days
Intensive Sprint
Week 1-2
- Master fundamentals: New Features For Performance
- Read Oracle official documentation
- Complete 8 questions daily
Week 3
- Deep dive: New Features For Database Infrastructure And Architecture
- Review weak areas from results
- Take 2 full-length exams
Week 4
- Review all flagged questions
- Timed exams to build stamina
- Final revision of key concepts
60 Days
Balanced Approach
Week 1-2
- Survey all exam domains
- Set up study environment
- Begin with foundational topics
Week 3-4
- Focus: New Features For Performance
- Focus: New Features For Database Infrastructure And Architecture
- 4 questions daily
Week 5-6
- Focus: New Features For Availability
- Hands-on labs if applicable
- Review explanations for wrong answers
Week 7-8
- Complete all 232 questions
- Identify and eliminate weak areas
- Take 3 full-length timed tests
90 Days
Comprehensive Study
Month 1
- Learn all exam domains at a comfortable pace
- Build strong foundational knowledge
- 3 questions daily
Month 2
- Deep dive into each domain
- Hands-on practice and labs
- Take weekly timed exams
Month 3
- Work through all 232 questions
- Identify and eliminate weak areas
- Take 3 full-length timed exams
1Z0-060-Specific Tips
- Focus heavily on the upgrade process itself—understand the pre-upgrade checks, upgrade tools (Database Upgrade Assistant), and rollback strategies specific to 12c
- Study Multitenant Architecture in depth: CDB (Container Database) and PDB (Pluggable Database) concepts are foundational to 12c and likely heavily tested
- Review new security features: Transparent Data Encryption enhancements, privilege analysis, and audit improvements in 12c
- Hands-on practice with 12c upgrades in a lab environment is critical—don't rely on documentation alone; execute actual upgrades
- Understand new performance features like In-Memory, Adaptive Query Optimization, and how they change execution plans
- Review the new storage features: ASM enhancements, compression options, and storage efficiency features introduced in 12c
- Study manageability improvements: Cloud Control integration, automated diagnostics, and new monitoring capabilities specific to 12c
Relevant Career Roles
Sample Questions
Try 5 free questions from the 1Z0-060 question bank
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME "TO_DATE (`08/20/12' , `MM/DD/YY')"; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
Oracle Data Redaction is active on the table. SCOTT.EMP You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?
You plan to drop the column of a table that has Flashback Archiving enabled. You want to ensure minimal service disruption. How would you do this in your Oracle 12c Database?
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
Related Certifications
Other Oracle certifications you might be interested in
1Z0-516
Oracle EBS R12.1 General Ledger Essentials
From $49.99
1Z0-071
Oracle Database 12c SQL
From $49.99
1Z0-062
Oracle Database 12c: Installation and Administration
From $49.99
1Z0-061
Oracle Database 12c: SQL Fundamentals
From $49.99
1Z0-517
Oracle EBS R12.1 Payables Essentials
From $49.99
1Z0-877
Oracle Solaris 10 System Administrator Certified Professional Exam, Part I
From $49.99
1Z0-060 FAQ
Ready to pass 1Z0-060?
Join thousands of professionals who passed their certification exam with NerdExam.
Get 1Z0-060 Exam Questions