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 16, 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?

Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore

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?

All administration tasks must be done to a specific pluggable database.

The pluggable databases increase patching time.

The pluggable databases reduce administration effort.

The pluggable databases are patched together.

Pluggable databases are only used for database consolidation.

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?

It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

It succeeds only if memory is available from the autotuned components if SGA.

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

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)?

The PDB must be open in read-only mode.

The PDB must be in mount state.

The PDB must be unplugged.

The PDB data files are always removed from disk.

A dropped PDB can never be plugged back into a multitenant container database (CDB).

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?

Compare Period ADDM report

AWR Compare Period report

Active Session History (ASH) report

Taking a new snapshot and comparing it with a preserved snapshot

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.