A purchase at PassSureExam is the start of a service relationship rather than the end of a transaction: after your 1Z1-060 order arrives, the team stays reachable around the clock for any Oracle Upgrade to Oracle Database 12c question that comes up.
Oracle 1Z1-060 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Upgrade to Oracle Database 12c |
| Exam Number: | 1Z0-060 |
| Exam Duration: | 120 minutes |
| Exam Format: | Multiple Choice |
| Exam Price: | 245 USD |
| Available Languages: | Japanese, English |
| Real Exam Qty: | 80 |
| Related Certifications: | Oracle Database 12c Administrator Certified Professional |
| Passing Score: | 64% |
| Certificate Validity Period: | 3 years |
| Recommended Training: | Oracle Database 12c: New Features for Administrators |
| Exam Registration: | Pearson VUE Scheduling Oracle University Registration |
| Sample Questions: | ![]() |
| Exam Way: | Online proctored or onsite at Pearson VUE test centers |
| Pre Condition: | Valid Oracle Database Administrator Certified Professional credential for versions 9i, 10g, or 11g |
| Official Syllabus URL: | https://education.oracle.com/upgrade-to-oracle-database-12c/pexam_1Z0-060 |
Oracle 1Z1-060 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Installation, Configuration and Tools | 15% | - Use Enterprise Manager Express - Use OUI and DBCA for installation and configuration - Configure server and client network |
| Topic 2: Storage and ILM Enhancements | 15% | - Information Lifecycle Management (ILM) and Temporal features - Index and partition enhancements - Manage tablespaces and ASM improvements |
| Topic 3: Security | 15% | - Implement column and tablespace encryption - Auditing and security policy management - Privilege analysis and separation of duties |
| Topic 4: New Features and Architecture | 15% | - Multitenant Container Database (CDB) and Pluggable Database (PDB) architecture - Multi-process multi-threaded Oracle architecture - Benefits and use cases of multitenant option |
| Topic 5: Backup, Recovery and Performance | 20% | - Use Data Recovery Advisor - Backup and recovery for CDB and PDB - Monitor and optimize memory and I/O - Database performance tuning and Resource Manager |
| Topic 6: CDB and PDB Administration | 20% | - Create and configure CDBs and PDBs - Start, stop and manage CDB/PDB instances - Manage common and local users, privileges and roles - Migrate non-CDB database to PDB |
1Z1-060 Exam Facts and the Service Behind Them
- Security (15%)
- Backup, Recovery and Performance (20%)
- New Features and Architecture (15%)
Oracle Upgrade to Oracle Database 12c Sample Questions:
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?
- A. Enabling resumable timeout for user sessions
- B. Decreasing the value of the IDLE_TIME resource limit in the default profile
- C. Setting a metric threshold
- D. Implementing Database Resource Manager
Correct Answer: D 🗳️
Explanation: Only visible for PassSureExam members. You can sign-up / login (it's free).
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 fails and reportsan error because the CONTAINER=CURRENT clause is not specified in the command.
- B. It executes successfully and creates an UNDO tablespace in HR_PDB.
- C. It executes successfully but neither tablespace nor the data file is created.
- D. It falls and reports an error because there can be only one undo tablespace in a CDB.
- E. It fails and reportsan error because the CONTAINER=ALL clause is not specified in the command.
Correct Answer: C 🗳️
Explanation: Only visible for PassSureExam members. You can sign-up / login (it's free).
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.
- A. Only for failed executions
- B. Both successful and failed executions
- C. SYS, SYSTEM
- D. Only for successful executions
- E. SCOTT
Correct Answer: B,C 🗳️
Explanation: Only visible for PassSureExam members. You can sign-up / login (it's free).
Identify three benefits of Unified Auditing.
- A. It improves overall auditing performance.
- B. It automatically audits Recovery Manager (RMAN) events.
- C. It guarantees zero-loss auditing.
- D. Decreased use of storage to store audit trail rows in the database.
- E. The audit trail cannot be easily modified because it is read-only.
Correct Answer: A,B,E 🗳️
Explanation: Only visible for PassSureExam members. You can sign-up / login (it's free).
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?
- A. The database must be opened with the RESETLOGSoption after the flashback is complete.
- B. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
- C. The database must have multiplexed redo logs for the flashback to succeed.
- D. The database must be MOUNTED for the flashback to succeed.
- E. The database must be opened in restricted mode for the flashback to succeed.
- F. The database must use block change tracking for the flashback to succeed.
Correct Answer: A,D 🗳️



