Create Next App

Exam contains 94 questions

Page 2 of 16

Question 7 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 8 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

D. Stage the patch on all cluster nodes.

Highly voted

Discussion of the question

Question 9 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 10 🔥

Which statement is true about Oracle Database 19c SGA Management?

Which database solution meets these requirements?

A. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.

Highly voted

B. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.

Highly voted

C. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

Highly voted

D. Oracle RAC Resource Management only allows assignment of the SGA during database startup.

Highly voted

Discussion of the question

Question 11 🔥

Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances.Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)

Which database solution meets these requirements?

C. When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.

Highly voted

A. Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

Highly voted

B. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriverupdate option.

Highly voted

D. Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

Highly voted

E. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.

Highly voted

Discussion of the question

Question 12 🔥

Examine this sequence of commands:The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

Which database solution meets these requirements?

F. The Oracle Clusterware stack is started on all nodes.

Highly voted

A. The Oracle Clusterware stack is stopped on all nodes.

Highly voted

B. The Oracle Clusterware stack is prevented from being automatically started on HOST01.

Highly voted

C. The Oracle Clusterware stack is prevented from being automatically started on all nodes.

Highly voted

D. The Oracle Clusterware stack is stopped on all nodes except HOST01.

Highly voted

E. The Oracle Clusterware stack is started on all nodes except HOST01.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_078

Exam contains 94 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us