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

Last updated: September 19, 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

   You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?

   Select 3 answers.

   • A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
   • B. The change tracking file must always be backed up when you perform a full database backup.
   • C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
   • D. More than one database block may be read by an incremental backup for a change made to a single block.
   • E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
   Reveal Answer

2. Question #2

   Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?

   
   • A. Data files that belong to only the root container
   • B. Data files that belong to the root container and all the pluggable databases (PDBs)
   • C. Data files that belong to only the root container and PDB$SEED
   • D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
   Reveal Answer

3. Question #3

   Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: \\1.Mount the CDB. \\2.Close all the PDBs. \\3.Open the database. \\4.Apply the archive redo logs. \\5.Restore the data file. \\6.Take the SYSAUX tablespace offline. \\7.Place the SYSAUX tablespace online. \\8.Open all the PDBs with RESETLOGS. \\9.Open the database with RESETLOGS. \\10.Execute the command SHUTDOWN ABORT. Which option identifies the correct sequence to recover the SYSAUX tablespace?

   • A. 6, 5, 4, 7
   • B. 10, 1, 2, 5, 8
   • C. 10, 1, 2, 5, 4, 9, 8
   • D. 10, 1, 5, 8, 10
   Reveal Answer

4. Question #4

   Identify three benefits of Unified Auditing.

   Select 3 answers.

   • A. Decreased use of storage to store audit trail rows in the database.
   • B. It improves overall auditing performance.
   • C. It guarantees zero-loss auditing.
   • D. The audit trail cannot be easily modified because it is read-only.
   • E. It automatically audits Recovery Manager (RMAN) events.
   Reveal Answer

5. Question #5

   Which two statements are true when row archival management is enabled?

   Select 2 answers.

   • A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
   • B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
   • C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
   • D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
   • E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
   Reveal Answer

6. Question #6

   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
   • E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
   Reveal Answer

7. Question #7

   You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12C. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions. After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs. How do you accomplish this?

   • A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
   • B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
   • C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
   • D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
   Reveal Answer

8. Question #8

   Which two statements are true about the Oracle Direct Network File system (DNFS)?

   Select 2 answers.

   • A. It utilizes the OS file system cache.
   • B. A traditional NFS mount is not required when using Direct NFS.
   • C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
   • D. Direct NFS is available only in UNIX platforms.
   • E. Direct NFS can load-balance I/O traffic across multiple network adapters.
   Reveal Answer

9. Question #9

   After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new default value for numeric full redaction?

   
   • A. Re-enable redaction policies that use FULL data redaction.
   • B. Re-create redaction policies that use FULL data redaction.
   • C. Re-connect the sessions that access objects with redaction policies defined on them.
   • D. Flush the shared pool.
   • E. Restart the database instance.
   Reveal Answer

10. Question #10

    Which two are prerequisites for performing a flashback transaction?

    Select 2 answers.

    • A. Flashback Database must be enable
    • B. Undo retention guarantee for the database must be configure
    • C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
    • D. Supplemental logging must be enable
    • E. Recycle bin must be enabled for the database.
    • F. Block change tracking must be enabled tor the database.
    Reveal Answer