Upgrade to Oracle Database 12c

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

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

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.

In which three ways can you re-create the lost disk group and restore the data?

    Correct Answer: C, D, F

    There are three ways to re-create a lost ASM disk group and restore the data: First, using the MD_RESTORE command with modified specifications for the restored disk group, followed by using RMAN to restore the data ensures flexibility in configuration while recovering the disk group (C). Second, using the MKDG command with the exact same configuration as the backed-up disk group and subsequently using RMAN to restore the data ensures that the disk group is re-created exactly as it was (D). Third, using the MKDG command to create a new disk group with the same or different specifications, then using RMAN to restore the data, provides an option to re-create a disk group with potentially improved configurations (F).

Question 2 of 40

Which two are true concerning a multitenant container database with three pluggable database?

    Correct Answer: C, D

    In a multitenant container database with pluggable databases, administration efforts are reduced because tasks such as backups and disaster recovery can be performed at the container database level, thereby simplifying these tasks. This makes it easier to manage multiple databases as a single unit. Additionally, when the container database is patched, all the pluggable databases within that container are patched together, ensuring consistent updates across all databases and further reducing administrative overhead.

Question 3 of 40

Examine the current values for the following parameters in your database instance:

SGA_MAX_SIZE = 1024M -

SGA_TARGET = 700M -

DB_8K_CACHE_SIZE = 124M -

LOG_BUFFER = 200M -

You issue the following command to increase the value of DB_8K_CACHE_SIZE:

SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

Which statement is true?

    Correct Answer: B

    The statement will succeed only if memory is available from the autotuned components of the SGA. This is because the current value of DB_8K_CACHE_SIZE is 124M, and increasing it to 140M requires an additional 16M. Since SGA_TARGET is less than SGA_MAX_SIZE, memory can be reallocated from other components within the SGA to accommodate this increase.

Question 4 of 40

Which statement is true concerning dropping a pluggable database (PDB)?

    Correct Answer: B

    To drop a pluggable database (PDB) in Oracle, the PDB must be in mount state. When a PDB is in mount state, it is neither open nor active, ensuring that the dropping operation can be performed safely without any access issues. This state allows the database to be properly detached and removed. It is not necessary for the PDB to be open in read-only mode or unplugged before dropping it. Additionally, dropping a PDB does not always remove its data files from the disk, and a dropped PDB can potentially be plugged back into a multitenant container database (CDB) if its metadata is properly reconstructed.

Question 5 of 40

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

    Correct Answer: B

    To identify performance changes in an Oracle 12c database, the AWR Compare Period report is the most suitable method. The Automated Workload Repository (AWR) captures database performance statistics, and its Compare Period report allows you to compare the performance metrics between two different time periods. This helps in pinpointing changes that could be responsible for the observed performance difference, making it a comprehensive tool for this task.