Oracle Database 12c Advanced Administration

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

  • You have 212 total questions to study from
  • Each page has 5 questions, making a total of 43 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on November 27, 2024
Question 1 of 212

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

    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 212

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

    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 212

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

    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 212

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?

    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 212

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.

    Correct Answer: D

    To recover a table from an RMAN backup to a specified point in time, you need to follow a logical sequence of steps. First, you need to determine which backup contains the table that needs to be recovered. Once identified, issue the recover table RMAN command specifying the auxiliary destination and point in time. Finally, create a Data Pump export dump file of the recovered table and import it back into the target instance. This ensures the table is restored to its correct state and integrated back into the main database.