Free 1z0-060: Upgrade to Oracle Database 12c Exam Questions and Answers

Last updated: August 30, 2026

Provider

Oracle

Questions in our bank

1000+

Free to read

First 10, with answers

Official page

Official Exam website

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   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 executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
   • B. It fails and reports an error because the CONTAINER=ALL clause is not use
   • C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
   • D. It fails and reports an error because the CONTAINER=CURRENT clause is not use
   Reveal Answer

2. Question #2

   A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?

   • A. Execute the query and view Active Session History (ASH) for information about the query.
   • B. Enable SQL trace for the query.
   • C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.
   • D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the
   Reveal Answer

3. Question #3

   Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command: 1snrctl > STOP What happens to the sessions that are presently connected to the database Instance?

   • A. They are able to perform only queries.
   • B. They are not affected and continue to function normally.
   • C. They are terminated and the active transactions are rolled back.
   • D. They are not allowed to perform any operations until the listener LISTENER is starte
   Reveal Answer

4. Question #4

   You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements: What is the result of the last SET CONTAINER statement and why is it so?

   • A. It succeeds because the PDB_ADMIN user has the required privileges.
   • B. It fails because common users are unable to use the SET CONTAINER statement.
   • C. It fails because local users are unable to use the SET CONTAINER statement.
   • D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
   Reveal Answer

5. Question #5

   Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

   • A. By default, EM express is available for a database after database creation.
   • B. You can use EM express to manage multiple databases running on the same server.
   • C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
   • D. You cannot start up or shut down a database Instance by using EM express.
   Reveal Answer

6. Question #6

   Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.

   • A. The optimizer used a dynamic plan for the query.
   • B. The optimizer chose different plans because automatic dynamic sampling was enable
   • C. The optimizer used re-optimization cardinality feedback for the query.
   • D. The optimizer chose different plan because extended statistics were created for the columns use
   Reveal Answer

7. Question #7

   Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

   • A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
   • B. All DDL commands are logged in the alert log file.
   • C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
   • D. Only DDL commands that resulted in the creation of new segments are logge
   Reveal Answer

8. Question #8

   You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: ? Version: Oracle Database 12c Releases 1 64-bit ? Character set: WE8ISO8859P15 ? National character set: AL16UTF16 ? O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: ? Version: Oracle Database 12c Release 1 64-bit ? Character set: AL32UTF8 ? O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

   • A. Transportable database
   • B. Transportable tablespace
   • C. Data Pump full export / import
   • D. The DBMS_PDB package
   Reveal Answer

9. Question #9

   After a successful upgrade to Oracle Database 12c, which view would you check to confirm the compatibility of the upgraded database?

   • A. DBA_REGISTRY
   • B. DBA_FEATURE_USAGE_STATISTICS
   • C. V$DATABASE
   • D. DBA_BA_REGISTRY
   Reveal Answer

10. Question #10

    Which Oracle Database 12c feature allows the use of multitenant architecture, which can contain multiple pluggable databases?

    • A. Data Pump
    • B. Oracle Streams
    • C. Oracle Grid Infrastructure
    • D. Multitenant Architecture
    Reveal Answer