Free 1z0-063: Oracle Database 12c Advanced Administration Exam Questions and Answers

Last updated: September 12, 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 the SPFILE, UNDO TABLESPACE is Set to UNDOTBS. 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

2. Question #2

   You are administering a multitenant container database (CDB) that contains two pluggable databases (PDBs), PDB1 and PDB2. You are connected to PDB2 as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB modifiable. As the user SYS, execute the following command on PDB2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?

   • A. The STATISTICS_LEVEL parameter is set to ALL when any of the PDBs is reopened.
   • B. The STATISTICS_LEVEL parameter is set to ALL only for PDB2 when it is reopened.
   • C. The STATISTICS_LEVEL parameter is set to ALL when the root database is restarted.
   • D. The statement is ignored because there is no SPFILE for a PDB.
   Reveal Answer

3. Question #3

   You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week. One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file. Examine the steps involved in the recovery process: 1. Shut down the database instance. 2. Start up the database instance in NOMOUNT state. 3. Mount the database. 4. Take the data file offline. 5. Put the data file online. 6. Restore the control file. 7. Restore the database. 8. Restore the data file. 9. Open the database with the RESETLOG option. 10. Recover the database with the NOREDO option. 11. Recover the data file with the NOREDO option. Identify the required steps in the correct order.

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

4. Question #4

   Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true?

   • A. The minimum size for the standard buffer cache is 100 MB.
   • B. The maximum size for the standard buffer cache is 100 MB.
   • C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
   • D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
   Reveal Answer

5. Question #5

   Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB): 1. RMAN initiates backup and passes the database backup storage selector to OSB. 2. RMAN creates the backup job. 3. OSB creates the backup job with an OSB user. 4. RMAN updates its repository. 5. RMAN executes the job and transfers data from a client to media. 6. OSB executes the job and transfers data from a client to media. 7. OSB updates its repository. Identify the required steps in the correct order.

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

6. Question #6

   Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

   • A. It can be executed only from CDB$ROOT.
   • B. It rolls back any pending transactions in the container from which it is executed.
   • C. It will not fire login triggers for the specified container.
   • D. It cannot be used to connect to PDB$SEED.
   Reveal Answer

7. Question #7

   The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user. A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open. In the CATDB12c database, you execute the commands: What is the outcome of the import?

   • A. It fails because the target database and recovery catalog database are of different versions.
   • B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
   • C. It succeeds but the database is not automatically registered in the RC12c catalog.
   • D. It fails because RMAN is not connected to the target database with DBID=1423241.
   Reveal Answer

8. Question #8

   Examine the following set of RMAN commands: Which statement is true about the RMAN RUN block execution?

   • A. The script is executed and both DC1 and CH1 channels are used for script execution.
   • B. The execution of the script fails because multiple channels cannot exist simultaneously.
   • C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
   • D. The new channel, CH1, is ignored because a channel has been configured already.
   Reveal Answer

9. Question #9

   RMAN is connected to a target database instance and an auxiliary instance. You execute the command: What is the outcome?

   • A. RMAN uses the push method to transfer image copies.
   • B. RMAN uses the push method to transfer backup sets.
   • C. RMAN uses the pull method to restore files using backup sets.
   • D. RMAN uses the pull method to restore files using image copies.
   Reveal Answer

10. Question #10

    You execute the commands to configure settings in RMAN: Then, you issue the following command to take a backup: Which statement is true about the execution of these commands?

    • A. The backup terminates because the backup destination for disk is not specified in the BACKUP command.
    • B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
    • C. It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.
    • D. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.
    Reveal Answer