Oracle Database 12c Advanced Administration

Here you have the best Oracle 1z0-063 practice exam questions

You have 266 total questions to study from
Each page has 5 questions, making a total of 54 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 23, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 266

Which two statements are true about scheduling operations in a pluggable database (PDB)?

Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

A job defined in a PDB runs only if that PDB is open.

Scheduler attribute setting is performed only at the CDB level.

Scheduler objects created by users can be exported or imported using Data Pump.

Scheduler jobs for a PDB can be created only by common users.

Correct Answer: B, D

A job defined in a pluggable database (PDB) runs only if that PDB is open. This ensures that the job does not attempt to execute on an inactive or inaccessible database, which would lead to errors. Scheduler objects created by users can be exported or imported using Data Pump, allowing for the transfer of scheduled jobs and other scheduler-related objects between databases, which is useful for backup, recovery, and migration purposes.

Question 2 of 266

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

Set the backup_tape_io_slaves parameter to true.

Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

Configure large pool if not already done.

Remove the rate parameter, if specified, in the allocate channel command.

Always use RMAN compression for tape backups rather than the compression provided by media manager.

Always use synchronous I/O for the database.

Correct Answer: B, C, D

To improve backup performance for a database, consider the following actions: First, set the 'dbwr_io_slaves' parameter to a nonzero value if synchronous I/O is in use, as this can help simulate asynchronous I/O on systems that do not support it natively. Second, configure the large pool if it is not already done. The large pool provides memory allocation for backup operations, reducing the likelihood of backup processes competing for shared pool memory. Finally, remove the 'rate' parameter in the allocate channel command, as it intentionally limits the backup rate to make more disk bandwidth available for other operations. These actions collectively help to optimize the backup process and improve overall performance.

Question 3 of 266

For which three pieces of information can you use the RMAN list command?

stored scripts in the recovery catalog

available archived redo log files

backup sets and image copies that are obsolete

backups of tablespaces

backups that are marked obsolete according to the current retention policy

Correct Answer: A, B, D

The RMAN LIST command can be used to display information about various elements managed by the RMAN repository. This includes stored scripts in the recovery catalog, available archived redo log files, and backups of tablespaces. These elements are critical for managing and recovering databases, which is why the LIST command provides visibility into them. Other options such as backup sets and image copies that are obsolete and backups marked as obsolete according to the current retention policy are not directly listed by the LIST command, but rather by other RMAN commands like DELETE and REPORT OBSOLETE.

Question 4 of 266

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?

Database Replay

Automatic Database Diagnostic Monitor (ADDM) Compare Period report

Active Session History (ASH) report

SQL Performance Analyzer

Correct Answer: B

The Automatic Database Diagnostic Monitor (ADDM) Compare Period report is the appropriate feature to use when you notice performance degradation in your production Oracle 12c database. This tool allows you to compare performance metrics over different time periods, helping to identify what changed and caused the performance difference. By analyzing trends and variations, ADDM can pinpoint specific issues and recommend actions to improve performance.

Question 5 of 266

Which three statements are true about a job chain?

It can contain a nested chain of jobs.

It can be used to implement dependency-based scheduling.

It cannot invoke the same program or nested chain in multiple steps in the chain.

It cannot have more than one dependency.

It can be executed using event-based or time-based schedules.

Correct Answer: A, B, E