Short on time before your 1Z1-060 exam date? The Oracle Upgrade to Oracle Database 12c question set from ActualCollection packs 205 practice questions into a format you can work through whenever a spare hour shows up. In 2026, plenty of busy professionals fit their prep into lunch breaks and commutes, and this material is built for exactly that.
Oracle 1Z1-060 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Upgrade to Oracle Database 12c |
| Exam Number: | 1Z0-060 |
| Available Languages: | English |
| Exam Duration: | 120 minutes |
| Real Exam Qty: | 80–85 |
| Exam Format: | Multiple Choice |
| Exam Price: | $245 USD (approx.) |
| Passing Score: | 65% (approx.) |
| Related Certifications: | Oracle Database 12c Administrator Certified Professional |
| Sample Questions: |  |
| Exam Way: | Oracle MyLearn online or testing centre delivery (Oracle CertView/Pearson VUE historically used). |
| Pre Condition: | Candidates typically have prior Oracle Database administration experience or OCA-level certification. |
| Official Syllabus URL: | https://education.oracle.com/upgrade-to-oracle-database-12c/pexam_1Z0-060 |
Oracle 1Z1-060 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Enterprise Manager and Tools | - Use Oracle Enterprise Manager Express and DBCA/OUI tools
|
| Topic 2: Multitenant Container Database (CDB) | - Multitenant architecture and benefits
|
| Topic 3: Storage Management | - Manage database structures and storage
|
| Topic 4: Configuring and Creating CDBs and PDBs | - Create and configure CDB and PDB
|
| Topic 5: Security | - Security policy and auditing
|
| Topic 6: Performance Management | - Database performance and tuning
|
Common Questions About the Oracle Upgrade to Oracle Database 12c Exam
The Oracle Upgrade to Oracle Database 12c exam is the official Oracle test registered under exam code 1Z1-060. Passing it earns you the Oracle Database certification, a credential at the Professional level. It is also linked to the related certification: Oracle Database 12c Administrator Certified Professional. Oracle exams are valued because they test job-ready skills, so a passing score here carries real weight on a resume.
The Oracle Upgrade to Oracle Database 12c exam includes 80–85 questions to be completed within 120 minutes. Do the pacing math before exam day: with that many items on the clock, you need a steady rhythm and the discipline to flag a hard question and move on instead of stalling. Two or three full timed sessions with the ActualCollection test engine will show you exactly what that pace feels like, so time pressure stops being a factor on the real day.
To pass the Oracle Upgrade to Oracle Database 12c exam you need 65% (approx.), and the official registration fee is $245 USD (approx.). A retake is not discounted: a failed attempt means paying the full $245 USD (approx.) again, so treat your first sitting as the expensive one. A sensible rule is to book your seat only after you are scoring comfortably above the passing mark on the ActualCollection practice tests, not just squeaking past it once.
Candidates typically have prior Oracle Database administration experience or OCA-level certification.
Eligibility rules do change from time to time, so confirm the current requirements before you register on the official exam page.
Yes. ActualCollection offers a free PDF demo of the Oracle Upgrade to Oracle Database 12c material so you can judge the question quality and format before spending anything. After purchase, your license includes 365 days of free updates, and if you want to keep receiving updates after that period, renewals are available at a 50% discount.
If you take the Oracle Upgrade to Oracle Database 12c exam within 60 days of your purchase and do not pass, ActualCollection backs you with a 100% money-back guarantee. The claim must match the exam your product covers: attempts taken within 3 days of purchase are not eligible (that is too little preparation time), and neither are downloaded-but-unused products, free materials, or expired orders. The candidate name must match the payer name, and you need to submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Prefer not to refund? You can swap instead and receive two other exam products of equal value for free while keeping the update service on your original purchase.
Delivery itself is instant: your files are downloadable right away and emailed to you within one minute of payment. If nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you may install the software on.
The official Oracle Upgrade to Oracle Database 12c syllabus is organized into 6 domains. Key areas include Performance Management, Storage Management, and Configuring and Creating CDBs and PDBs. The complete, up-to-date topic list appears in the exam topics section above; work through it line by line and flag anything you cannot yet explain in your own words.
Oracle Upgrade to Oracle Database 12c Sample Questions:
Question 1
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality feedback?
A. The optimizer can re optimize a query only once using cardinality feedback.
B. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
E. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
Question 2
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file
`/u01/app/oracle/oradata/CDB1/temp01.tmp'
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.
A. Shut down the database instance and then restart the CDB and PDBs.
B. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
C. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
D. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
E. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
Question 3
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:
What is the result?
A. It falls and reports an error because there can be only one undo tablespace in a CDB.
B. It executes successfully and creates an UNDO tablespace in HR_PDB.
C. It fails and reportsan error because the CONTAINER=CURRENT clause is not specified in the command.
D. It fails and reportsan error because the CONTAINER=ALL clause is not specified in the command.
E. It executes successfully but neither tablespace nor the data file is created.
Question 4
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?
A. All the components may be moved into SYSAUX tablespace.
B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
C. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
D. All the components may be moved from the SYSAUX tablespace.
Question 5
What are three purposes of the RMAN "FROM SERVICE" clause?
A. to support synchronization of a standby database with the primary database in a Data Guard environment
B. to support file restoration over the network in a Data Guard environment
C. to support file recovery over the network in a Data Guard environment
D. to support PUSH-based active database duplication
E. to support active database duplication by taking image copies of the source database
Solutions:
| Question 1 Answer: B,C,E | Question 2 Answer: A,B | Question 3 Answer: E | Question 4 Answer: B,C | Question 5 Answer: A,C,E |
919 Customer Reviews
