Last Updated: Sep 04, 2026
No. of Questions: 205 Questions & Answers with Testing Engine
Download Limit: Unlimited
Our Online Test Engine & Self Test Software of TestSimulate 1Z1-060 actual study materials can simulate the exam scene so that you will have a good command of writing speed and time. Then multiple practices make you perfect while in the real Oracle 1Z1-060 exam. The package practice version will not only provide you high-quality 1Z1-060 exam preparation materials but also various studying ways.
TestSimulate has an unprecedented 99.6% first time pass rate among our customers.
We're so confident of our products that we provide no hassle product exchange.
From your first practice test to the day you book the exam, TestSimulate covers the whole Oracle Upgrade to Oracle Database 12c journey: 205 regularly updated questions, three study formats, 365 days of free updates, and a conditional money back guarantee. For busy professionals in 2026, one reliable source of 1Z1-060 preparation beats a dozen half-finished resources.
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 12c: Upgrade |
| Exam Number: | 1Z0-060 |
| Exam Duration: | 120 minutes |
| Related Certifications: | Oracle Database 12c Administrator Certified Professional Oracle Database 11g Administrator Certified Professional |
| Certificate Validity Period: | Oracle Certification typically does not expire (subject to Oracle policy updates) |
| Exam Format: | Multiple Choice, Multiple Response |
| Exam Price: | USD 245 (varies by region) |
| Passing Score: | 60% |
| Real Exam Qty: | 50-70 |
| Available Languages: | English |
| Recommended Training: | Oracle University Training |
| Exam Registration: | Oracle Certification Registration Pearson VUE Oracle Exams |
| Sample Questions: | Oracle 1Z1-060 Sample Questions |
| Exam Way: | Online proctored or Pearson VUE test center exam delivery |
| Pre Condition: | Recommended: Oracle Database 11g Administrator experience and familiarity with database administration concepts |
| Official Syllabus URL: | https://education.oracle.com/ |
| Section | Objectives |
|---|---|
| Topic 1: Data Migration and Move Strategies | - Transportable Tablespaces
|
| Topic 2: Upgrade Methods | - Database Upgrade Assistant (DBUA)
|
| Topic 3: Pre-Upgrade Preparation | - Pre-Upgrade Utilities
|
| Topic 4: Post-Upgrade Tasks | - Database Validation
|
| Topic 5: Oracle Database 12c Architecture | - Database Architecture Changes in 12c
|
The 1Z1-060 exam is the official Oracle exam behind Oracle Upgrade to Oracle Database 12c — passing it earns you the Oracle Database 12c Administrator / Upgrade Certification Track certification, a credential positioned at the Professional level. It is built for candidates who want to validate the skills measured by Oracle Upgrade to Oracle Database 12c. Depending on your track, the exam is also linked to the Oracle Database 11g Administrator Certified Professional and Oracle Database 12c Administrator Certified Professional certifications, so one pass can move you toward more than one Oracle credential.
The 1Z1-060 exam presents 50-70 questions to be completed within 120 minutes. That pace leaves little room for second-guessing: read each question carefully on the first pass, flag the ones you want to revisit, and keep moving instead of stalling on a single item. Before exam day, run at least one full timed session in the TestSimulate desktop or online test engine with a comparable question load — a steady rhythm under the clock is a trainable skill, and it is often what separates a pass from a near miss.
To pass the 1Z1-060 exam you need 60%, and the official registration fee is USD 245 (varies by region). Keep in mind that a failed attempt means paying that fee again in full — retakes are not discounted. Given the cost, self-test before you book: if you can score comfortably above the passing mark on two or three consecutive timed TestSimulate practice tests, your budget is far better spent on the exam itself than on a retake.
Recommended: Oracle Database 11g Administrator experience and familiarity with database administration concepts Because Oracle revises its certification programs from time to time, treat this as a starting point rather than the final word. Confirm the current eligibility requirements on the official Oracle exam page before you register.
Registration for the 1Z1-060 exam is handled through the official channels below:
Delivery method: Online proctored or Pearson VUE test center exam delivery — pick the option that suits you best when booking your slot.
Oracle points Oracle Upgrade to Oracle Database 12c candidates toward the following official courses:
Official courses build the foundation; pairing them with the 205 1Z1-060 practice questions from TestSimulate turns that knowledge into exam-day readiness.
Yes. A free PDF demo of the 1Z1-060 practice questions is available, so you can check the question style and answer quality before spending anything. Every purchase also includes 365 days of free updates — whenever Oracle adjusts the Oracle Upgrade to Oracle Database 12c blueprint, your material is refreshed at no cost during that period. After the first year, you can extend the update service at a 50% discount from your member zone.
TestSimulate backs your purchase with a 100% Money Back Guarantee. If you take the corresponding exam within 60 days of purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip together with the official Score Report PDF within 2 days of your exam date; approved claims are processed within 7 days. The guarantee applies only to the exam matching your purchase, the candidate name must match the payer name, and it does not cover attempts taken within 3 days of purchase, candidates who downloaded the material but never sat the exam, expired orders, or free materials. If you would rather keep preparing, you can exchange the product for two free exam preparation packages of equal value and keep the update service on your original purchase.
Delivery is instant: your download is available right after payment, and a copy is emailed to you within one minute. If nothing arrives within 2 hours, check your spam folder and contact our support team. There is no limit on the number of computers you can install the software on.
The Oracle Upgrade to Oracle Database 12c syllabus is organized into 5 domains. Among the headline areas are Post-Upgrade Tasks, Data Migration and Move Strategies, Upgrade Methods. Rather than copying every subtopic here, we keep the complete, current outline in the Exam Topics section above — work through it domain by domain with the TestSimulate 1Z1-060 practice questions so nothing on the blueprint catches you off guard.
Question 1
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:
Which two statements are true? (Choose two.)
A. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
B. The schema for the common user C # # A_ADMIN can be different in each container.
C. The command will, create a common user whose description is contained in the root and each PDB.
D. The command will create a user in the root container only because the container clause is not used.
E. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
Question 2
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?
A. Mount the container database (CDB) and restore the control file from the control file auto backup.
B. Recover and open the CDB in NORMAL mode.
C. Recover each pluggable database.
D. Mount the CDB and then recover and open the database, with the RESETLOGS option.
E. Open all the pluggable databases.
F. Start the database instance in the nomount stage and restore the control file from control file auto backup.
Question 3
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?
A. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
B. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
C. It fails and reports an error because the CONTAINER=ALL clause is not used.
D. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
E. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
Question 4
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
A. Contains a cursor area for storing runtime information about cursors
B. Contains stack space
C. Allocates memory for RMAN backup and restore operations
D. Contains a hash area performing hash joins of tables
E. Allocates memory for shared and private SQL areas
Question 5
You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
- RANDOM redaction on the SAL and COMM columns
- PARTIAL redaction on the HIREDATE column
- FULL redaction on the MGR column
What would you define to implement this?
A. several redaction policies, with one redaction policy foe each data type defined for the table must be redacted
B. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type
C. several redaction policies, with one redaction policy for each table column that must be redacted
D. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted
Solutions:
| Question 1 Answer: B,C | Question 2 Answer: D,E,F | Question 3 Answer: D | Question 4 Answer: A,C,D | Question 5 Answer: D |
Edward
Haley
Jonathan
Martin
Hayden
Kennedy
Merle
TestSimulate is the world's largest certification preparation company with 99.6% Pass Rate History from 74001+ Satisfied Customers in 148 Countries.
Over 74001+ Satisfied Customers
