Oracle 1z0-078 Exam Dumps

Question 6 of 47

Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)

A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

An ACFS snapshot can be ACFS encrypted.

acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

acfsutil encr on can be used to specify the encryption key length for a directory or file.

acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.

Correct Answer: A, B, D

A copy of an encrypted file is not encrypted unless it is created in an encrypted directory, meaning that file-specific encryption does not necessarily transfer during copy unless within an encrypted directory. An ACFS snapshot can indeed be ACFS encrypted. The command acfsutil encr on can be used to specify the encryption key length for a directory or file, allowing customization of encryption strength. The suggested answer mentioned role separation for encryption managers and auditors, but that is a misunderstanding of the acfsutil encr init command's purpose. Role separation is not established by that command.

Question 7 of 47

For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)

Cluster resources

Database transactions

Local resources

Administrator-defined resources

Pluggable Databases (PDBs)

Correct Answer: A, C, D

The 'what-if' command evaluation in Oracle 19c Clusterware can be used to determine the impact on cluster resources, local resources, and administrator-defined resources. This allows administrators to simulate changes and understand their impact on resource configurations and cluster operations without actually making the changes. The 'what-if' scenario planning helps in preventing potential issues by providing a preview of the outcomes of various management operations.

Question 8 of 47

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

Global Enqueues may have converters and waiters in the same instance.

Global Enqueues may have owners and waiters in the same instance.

Global Enqueues and Instance Locks replace latches completely in RAC database instances.

In a RAC database, there is no LMD0 process if only one instance is running.

In a RAC One Node database, there is no LMD0 process if only one instance is running.

Correct Answer: B, C

Global Enqueues may have owners and waiters in the same instance and may have converters and waiters in the same instance. These statements are true because they accurately describe the behavior of global enqueues in Oracle 19c RAC. Other options either overstate or misinterpret the functionality of Global Enqueues, Instance Locks, or the LMD0 process.

Question 9 of 47

Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?

Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.

Stage the patch on the cluster node where the OPatch utility will be executed.

Update the PATH environment variable on the node where you will run the OPatch utility to point to the $ORACLE_HOME/OPatch directory.

Stage the patch on all cluster nodes.

Correct Answer: C

Before running the OPatch utility to patch Oracle Grid Infrastructure 19c, you must update the PATH environment variable on the node where you will run the OPatch utility to point to the $ORACLE_HOME/OPatch directory. This ensures that the correct version of OPatch is used during the patching process and allows the utility to locate the necessary files and libraries.

Question 10 of 47

Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)

The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM).

The diagcollection.pl script must be run from the Grid home directory as the grid infrastructure owner.

There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM ) repository.

There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

Correct Answer: D, E

The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository. Additionally, there is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of the cluster size. These statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware.