Upgrade Oracle9i10g11g OCA OR OCP to Oracle Database 12c OCP Exam Questions

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

Some things you may want to keep in mind about this practice exam questions:

You have 53 total questions to study from
Each page has 5 questions, making a total of 11 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on September 18, 2024

Question 1 of 53

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

A.

Set the backup_tape_io_slaves parameter to true.

B.

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

C.

Configure large pool if not already done.

D.

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

E.

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

F.

Always use synchronous I/O for the database.

Correct Answer: ACD

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 2 of 53

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

A.

stored scripts in the recovery catalog

B.

available archived redo log files

C.

backup sets and image copies that are obsolete

D.

backups of tablespaces

E.

backups that are marked obsolete according to the current retention policy

Correct Answer: ABD

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 3 of 53

Which three statements are true about a job chain?

A.

It can contain a nested chain of jobs.

B.

It can be used to implement dependency-based scheduling.

C.

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

D.

It cannot have more than one dependency.

E.

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

Correct Answer: ABE

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.

Question 4 of 53

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

Correct Answer: D

To recover a table from an RMAN backup to a specified point in time due to logical corruption, you need to determine the backup containing the table, issue the recover table RMAN command with the appropriate parameters, and then create a Data Pump export dump file for the recovered table. Step 1 is necessary to identify the correct backup, step 2 involves using the RMAN recover table command with the auxiliary destination and specified recovery time, and step 4 allows for the creation of the dump file on the target database. Importing the Data Pump export dump file into the auxiliary instance (step 3) is not required in this process. Hence, the correct sequence is 1, 2, 4.

Question 5 of 53

Examine the command:

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

In which two scenarios is this command required?

A.

The current online redo log file is missing.

B.

A data file belonging to a noncritical tablespace is missing.

C.

All the control files are missing.

D.

The database backup is older than the control file backup.

E.

All the data files are missing.

Correct Answer: AD

The command 'RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;' is used in scenarios where the current state of the control file is unreliable or missing, requiring the use of a backup control file to proceed with recovery. One common scenario is when the current online redo log file is missing, making it necessary to use a backup control file (Option A). Another scenario is when the database backup is older than the control file backup, necessitating this command to ensure consistency during the recovery process (Option D).