Upgrade Oracle9i10g11g OCA OR OCP to Oracle Database 12c OCP

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

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

Question 1 of 176

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

Question 2 of 176

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: A, C, D

To improve backup performance, setting the backup_tape_io_slaves parameter to true can help by utilizing multiple I/O slaves for tape backups, which enhances throughput. Configuring the large pool if not already done is beneficial because it provides a dedicated memory area for backup and restore operations, improving performance by reducing contention for the shared pool. Removing the rate parameter in the allocate channel command, if specified, can also improve backup performance by allowing RMAN to use the maximum available bandwidth without artificially limiting the rate of data transfer.

Question 3 of 176

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 list stored scripts in the recovery catalog, available archived redo log files, and backups of tablespaces. The list command provides information about the stored scripts, which are an integral part of the recovery catalog. It also provides details on archived redo logs, which are crucial for recovery operations. Additionally, it includes information about backups of tablespaces, which are necessary for restoring data. Backup sets and image copies that are obsolete (Option C) and backups that are marked obsolete according to the current retention policy (Option E) are generally managed by other commands such as REPORT OBSOLETE.

Question 4 of 176

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

Question 5 of 176

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

A job chain can contain a nested chain of jobs, allowing complex workflows to be constructed. It can be used to implement dependency-based scheduling, where jobs are executed based on the completion of other jobs. Additionally, it can be executed using event-based or time-based schedules, providing flexibility in how and when the job chain is triggered.