Hiring managers recognize Oracle certifications on sight, and the Oracle Upgrade to Oracle Database 12c exam is the gate you have to pass through. The 205 practice questions at ActualCollection keep your preparation aligned with what the exam actually measures.
Oracle 1Z1-060 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 12c: Upgrade |
| Exam Number: | 1Z0-060 |
| Available Languages: | English |
| Passing Score: | 60% |
| Real Exam Qty: | 50-70 |
| Certificate Validity Period: | Oracle Certification typically does not expire (subject to Oracle policy updates) |
| Exam Price: | USD 245 (varies by region) |
| Exam Format: | Multiple Choice, Multiple Response |
| Related Certifications: | Oracle Database 11g Administrator Certified Professional Oracle Database 12c Administrator Certified Professional |
| Exam Duration: | 120 minutes |
| Recommended Training: | Oracle University Training |
| Exam Registration: | Oracle Certification Registration Pearson VUE Oracle Exams |
| Sample Questions: | DOWNLOAD DEMO |
| 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/ |
Oracle 1Z1-060 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Data Migration and Move Strategies | - Data Pump Import/Export
|
| Pre-Upgrade Preparation | - Compatibility and Requirements
|
| Post-Upgrade Tasks | - Database Validation
|
| Upgrade Methods | - Database Upgrade Assistant (DBUA)
|
| Oracle Database 12c Architecture | - Database Architecture Changes in 12c
|
1Z1-060 (Oracle) Exam FAQs: What Candidates Ask Most
Oracle Upgrade to Oracle Database 12c is an official Oracle exam, registered under the code 1Z1-060. A passing score earns you the Oracle Database 12c Administrator / Upgrade Certification Track certification, positioned at the Professional level. The credential also connects to Oracle Database 11g Administrator Certified Professional, Oracle Database 12c Administrator Certified Professional, so it can anchor a broader certification path. Because Oracle designs its exams around real job tasks, holding this certification signals practical skill rather than memorized theory.
Candidates face 50-70 questions inside a 120 minutes window on the Oracle Upgrade to Oracle Database 12c exam. That ratio leaves little slack, which is why pacing deserves as much practice as the content itself. Learn to budget your minutes, park stubborn questions instead of wrestling them, and rehearse under a real clock: a few timed runs in the ActualCollection test engine will make the official time limit feel routine rather than threatening.
The passing bar for Oracle Upgrade to Oracle Database 12c is set at 60%, and registering for the exam officially costs USD 245 (varies by region). There is no reduced price for a second try: fail, and you pay USD 245 (varies by region) in full again. That makes honest self-testing the cheapest insurance available, so hold off on booking until your ActualCollection practice scores sit clearly above the passing line, attempt after attempt.
Recommended: Oracle Database 11g Administrator experience and familiarity with database administration concepts
Vendor policies are revised from time to time, so double-check the eligibility details before registering on the official exam page.
Sign-up for the Oracle Upgrade to Oracle Database 12c exam is handled through the official registration channels listed here.
One practical detail: the exam is delivered Online proctored or Pearson VUE test center exam delivery, so plan your logistics accordingly.
Oracle recommends the following training resources for candidates working toward Oracle Upgrade to Oracle Database 12c.
Training gives you the theory, but repetition locks it in. Pair any course with the 205 practice questions in the ActualCollection 1Z1-060 package and you will know exactly how each topic shows up on exam day.
Absolutely. A free PDF demo of the Oracle Upgrade to Oracle Database 12c questions is available at ActualCollection, so you can inspect the quality and formatting before any money changes hands. Once you buy, updates are free for 365 days, and when that period runs out you can extend the update service at 50% off the regular price.
ActualCollection offers a 100% money-back guarantee with specific conditions. If you take the Oracle Upgrade to Oracle Database 12c exam within 60 days of purchase and fail, you may claim a full refund, provided the exam matches your product. Sitting the exam within 3 days of purchase disqualifies a claim, as do downloaded-but-unused products, free materials, and expired orders; the candidate name must also match the payer name. To file, submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the claim is processed within 7 days. If you prefer, you can skip the refund and instead receive two other exam products of equal value at no charge while keeping the update service on your original purchase.
As for delivery: it is immediate. Your files become downloadable the moment payment completes and are also emailed to you within one minute. If nothing shows up within 2 hours, contact customer service. You may install the software on an unlimited number of computers.
Oracle Upgrade to Oracle Database 12c is divided into 5 official domains. Among the headline areas are Upgrade Methods, Oracle Database 12c Architecture, and Pre-Upgrade Preparation. Scroll up to the exam topics section for the full breakdown, and use it as a checklist: any line you cannot confidently explain deserves another round of practice.
Oracle Upgrade to Oracle Database 12c Sample Questions:
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?
- A. Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re- associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA - B. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
- C. Drop the column using the ALTER TABLE statement.
- D. Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA - E. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
Correct Answer: C 🗳️
Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?
- A. Restart the database Instance in RESTRICTED mode.
- B. Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.
- C. Set the MAX_STRING_SIZE parameter to EXTENDED.
- D. Run the Database Migration Assistant.
- E. Shut down the database instance.
- F. Restart the instance in normal mode.
- G. Restart the database instance in UPGRADE mode.
Correct Answer: B,C,E,F,G 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
- A. Contains a hash area performing hash joins of tables
- B. Contains a cursor area for storing runtime information about cursors
- C. Contains stack space
- D. Allocates memory for shared and private SQL areas
- E. Allocates memory for RMAN backup and restore operations
Correct Answer: A,B,E 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1
service.
3. An aggregated trace file is created for all the sessions that are
running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?
- A. 2 and 5
- B. 3 and 4
- C. 1
- D. 3 and 5
- E. 2 and 4
Correct Answer: E 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
What is the result?
- A. The file `myfile.dbf' is created in `+data/prod' and the reference to `+data.231.45678' in the data dictionary removed.
- B. The file `+data.231.45678' is physically relocated to `+data/prod' and renamed as `myfile.dbf'.
- C. The file `+data.231.45678' is renamed as `myfile.dbf', and copied to `+data/prod'.
- D. The file `+data.231.45678' remains in the same location andasynonym'myfile.dbf' is created.
Correct Answer: D 🗳️
Explanation: Only visible for ActualCollection members. You can sign-up / login (it's free).
Rosemary 
Tammy 
Marsh 
Primo 
Marsh 
Mona 
Max 
Olive 
Bard 
Joyce 
Herbert 
Elaine 
Sandy 
Angela 
Alvin 
Jesse 
Carr 
Bob 
Aldrich 
Alston 
