Oracle Database 12c: Advanced Administration - 1z0-063 Exam Questions [2026]

QUESTION NO: 1
Which two statements are true about RMAN duplexed backups? (Choose two.)

A. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously. B. It is not supported for image copies. C. Duplex backups can contain only data files and control files. D. It is only supported for backups to tape via the media management interface. E. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

Correct Answer: A,B

QUESTION NO: 2
Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN.
Identify the minimum requirement for accomplishing the task.

A. All tablespaces in the database must be locally managed. B. An RMAN channel must be configured to device-type disk. C. The database must be configured in ARCHIVELOG mode. D. Redo log groups must have at least two members each.

Correct Answer: C

QUESTION NO: 3
Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

A. A password encryption of backups uses the password while creating and restoring backups. B. Encrypted backups can only be written to disk. C. Image copy backups can be created by using password encryption. D. Transparent encryption of backups uses an encryption wallet. E. A database uses the same encryption key for every encrypted backup.

Correct Answer: A,D

QUESTION NO: 4
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)

A. A program can be used in the definition of multiple jobs. B. A program and job can be specified as part of a schedule definition. C. A program and schedule can be specified as part of a job definition. D. A job is specified as part of a program definition. E. A program and window can be specified as part of a job definition.

Correct Answer: A,C,E

QUESTION NO: 5
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

A. You can rename tables during import. B. You can overwrite existing dump files during export. C. You can compress data but not metadata during export. D. You cannot export data from a remote database.

Correct Answer: A,B

QUESTION NO: 6
When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when the undo tablespace is of a fixed size and retention guarantee is not enabled B. when Flashback Database is enabled C. when there are multiple undotablespaces available in a database D. when the data file of the undo tablespace is autoextensible

Correct Answer: A

QUESTION NO: 7
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

A. 1, 4, 6, 5, 8, 3, 9 B. 1, 6, 4, 5, 8, 3, 9 C. 2, 4, 5, 8, 3, 7, 9 D. 2, 4, 6, 5, 8, 3, 7

Correct Answer: D

QUESTION NO: 8
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTION 2 YEAR;
What is the outcome?

A. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time. B. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years. C. An error is returned because the retention period cannot be reduced. D. All historical data older than two years, if any, is purged from the flashback archive FDA1.

Correct Answer: B

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

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

Correct Answer: E

QUESTION NO: 10
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

A. Active Session History (ASH) report B. SQL Performance Analyzer C. Database Replay D. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

Correct Answer: D

QUESTION NO: 11
Examine this command:

Which two statements are true after successful execution? (Choose two.)

A. A metadata description of PDB2 is stored in an XML file in '/disk2/oracle/pdb2/'. B. A metadata description of PDB2 is stored in the system tablespace of PDB1. C. PDB2 will be in MOUNT state. D. PDB2 will use shared UNDO. E. PDB2 will be open read-only.

Correct Answer: B,C

QUESTION NO: 12
You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening PDB_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf' To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

A. The command performs the recovery and closes the failure. B. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command. C. The command executes successfully, performs recovery, and opens PDB_1. D. The command produces an error because RMAN is not connected to the target database PDB_1.

Correct Answer: B

QUESTION NO: 13
Which three statements are true about the database instance startup after an instance failure? (Choose three.)

A. Changes committed before the failure, which were not written to the data files, are re-applied. B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery. C. Uncommitted changes are rolled back to ensure transactional consistency. D. The SMON process coordinates the database recovery. E. The RECO process recovers the uncommitted transactions at the next instance startup. F. Media recovery is required to complete the database recovery.

Correct Answer: C,D,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 14
View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start?

A. because memory_target and memory_max_target cannot be equal B. because pga_aggregate_target is not set C. because sga_target and memory_target are both set D. because statistics_level is set to basic

Correct Answer: D