Free 1z0-067: Upgrade Oracle9i10g11g OCA OR OCP to Oracle Database 12c OCP Exam Questions and Answers

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

   Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time. Examine the steps to recover this table from an RMAN backup: 1. Determine which backup contains the table that needs to be recovered. 2. Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified. 3. Import the Data Pump export dump file into the auxiliary instance. 4. Create a Data Pump export dump file that contains the recovered table on a target database. Identify the required steps in the correct order.

   • A. 1, 4, 3
   • B. 1, 2
   • C. 1, 4, 3, 2
   • D. 1, 2, 4
   Reveal Answer

2. Question #2

   In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS. You rename the undotbs undo tablespace: ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is true?

   • A. The tablespace will be renamed but the data file headers will not be updated.
   • B. The statement will fail because you cannot rename an undo tablespace.
   • C. The tablespace will be renamed and all the changes will be logged in the alert log.
   • D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
   Reveal Answer

3. Question #3

   Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

   • A. SQL Performance Analyzer
   • B. SQL Access Advisor
   • C. SQL Tuning Advisor
   • D. Automatic Workload Repository (AWR) report
   Reveal Answer

4. Question #4

   You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

   • A. The event parameter was not set.
   • B. The sql_trace parameter is set to false.
   • C. Enterprise Manager was not used.
   • D. The statistics_level parameter is set to basic.
   Reveal Answer

5. Question #5

   You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database: CONNECT/AS SYSDBA ALTER SYSTEMSETTHREADED EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE You then restart the instance and get an error: STARTUP ORA-01031:insufficientprivileges Why does the startup command return the error shown?

   • A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command
   • B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
   • C. because the threaded architecture requires authentication using a password file before issuing a startup command
   • D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
   Reveal Answer

6. Question #6

   Examine the command: $expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statement is true about the execution of the command?

   • A. It fails because the log file parameter is not specified.
   • B. It fails because no absolute path is specified for the log file and dump file.
   • C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
   • D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed
   Reveal Answer

7. Question #7

   Your database supports an OLTP workload. Examine the output of the query: SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttr estimated_mttr ---------------------- --------------------------- 0 76 To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30. What is the effect of this setting on the database?

   • A. Automatic checkpoint tuning is disabled.
   • B. The frequency of log switches is increased.
   • C. The overhead on database performance is increased because of frequent writes to disk.
   • D. The MTTR advisor is disable
   Reveal Answer

8. Question #8

   Which parameter must be set to which value to implement automatic PGA memory management?

   • A. Set memory_target to zero.
   • B. Set STATISTICS_LEVEL to BASIC.
   • C. Set pga_aggregate_target to a nonzero value.
   • D. Set pga_aggregate_target and sga_target to the same value.
   Reveal Answer

9. Question #9

   The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database. NAME TYPE VALUE -------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring What is the location of the ADR base?

   • A. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
   • B. It is set to /u01/app/oracle/admin/en12.1.0/adump.
   • C. It is set to /u01/app/oracle.
   • D. It is set to /u01/app/oracle/flash_recovery_are
   Reveal Answer

10. Question #10

    Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost. Examine the steps to restore the SPFILE and the control file to mount the database: 1. Set DBID of the target database in RMAN. 2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN. 3. Restore the control files from the backup. 4. Mount the database. 5. Restore the SPFILE from the autobackup. 6. Create a PFILE from the recovered SPFILE. 7. Restart the instance in NOMOUNT state. Identify the required steps in the correct order.

    • A. 1, 2, 5, 3, 6, 4
    • B. 1, 2, 3, 5, 6, 4
    • C. 2, 1, 5, 7, 3, 4
    • D. 2, 1, 5, 6, 7, 4, 3
    Reveal Answer