Free Oracle 1Z0-060 Exam Actual Questions

The questions for 1Z0-060 were last updated On Nov 11, 2024

Question No. 1

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

Show Answer Hide Answer
Correct Answer: A, E, F

Manually Sized SGA Components that Use SGA_TARGET Space

SGA Component, Initialization Parameter

/ The log buffer

LOG_BUFFER

/ The keep and recycle buffer caches

DB_KEEP_CACHE_SIZE

DB_RECYCLE_CACHE_SIZE

/ Nonstandard block size buffer caches

DB_nK_CACHE_SIZE

Note:

* In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.

* Table, Automatically Sized SGA Components and Corresponding Parameters


Question No. 2

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)

Show Answer Hide Answer
Correct Answer: D, E

Question No. 3

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? (Choose three.)

Show Answer Hide Answer
Correct Answer: B, C, E

Question No. 4

Which statement is true concerning compression during an Online Datafile Move?

Show Answer Hide Answer
Correct Answer: A

Question No. 5

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE'' statement?

Show Answer Hide Answer
Correct Answer: B

* The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.

Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

* Creating a PDB

Rather than constructing the data dictionary tables that define an empty PDB from scratch,

and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB

is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred

to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a

seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual

significance; rather, it is just an optimization device. The create PDB operation is implemented

as a special case of the clone PDB operation.