Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database 19c 1z0-078 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.
Exam 1z0-078 Premium Access

View all detail and faqs for the 1z0-078 exam


684 Students Passed

84% Average Score

93% Same Questions
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

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

Options:

A.

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

B.

The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.

C.

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

D.

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

E.

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

Questions # 12:

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

Options:

A.

Database block buffers

B.

Mutexes

C.

Redo log buffers

D.

Latches

E.

Enqueues

F.

Cursors

Questions # 13:

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

Options:

A.

SSH user equivalence for the Oracle user can be set up before the software installation.

B.

Fix-up scripts generated during the installation must be run as root on UNIX platforms.

C.

The software must be installed into a local file system on each node.

D.

The software must be installed into a cluster file system.

E.

RAC installations require Oracle Enterprise Edition.

F.

The software can be installed into an ACFS file system.

G.

The software must be installed on all nodes in the cluster.

Questions # 14:

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

Options:

A.

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

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.

C.

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

D.

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

Questions # 15:

Which two steps must always be performed to delete nodehost04from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)

Options:

A.

Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.

B.

Run the crsctl delete node -n host04 command as root on host04.

C.

Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

D.

Run the crsct1 unpin css - host04 command as root on host04.

E.

Run the rootcrs.pl -deconfig -force command as root on host04.

F.

Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

Questions # 16:

Which three statements are true about undo management in a RAC environment? (Choose three.)

Options:

A.

You can dynamically assign a newly created undo tablespace to an instance.

B.

In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

C.

An instance that performs instance recovery can write to the undo tablespace of a failed instance.

D.

A mixture of automatic undo management and manual undo management is supported within a RAC database.

E.

It is necessary to assign a specific undo tablespace to a specific instance.

Questions # 17:

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

Options:

A.

Cluster resources

B.

Database transactions

C.

Local resources

D.

Administrator-defined resources

E.

Pluggable Databases (PDBs)

Questions # 18:

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)

Options:

A.

If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

B.

The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

C.

If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

D.

ASM disk groups used for voting files and OCR files require a quorum failqroup.

E.

The Installer permits the creation of a disk group for use by the voting disks and OCR file.

Questions # 19:

Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

Options:

A.

The Grid Infrastructure Management Repository is only required when using ASM.

B.

Specifying the use of Grid Naming Service is optional.

C.

Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of

D.

The Clusterware binaries may be installed without installing ASM binaries.

E.

High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

Questions # 20:

Which three statements are true about fully qualified file names in ASM? (Choose three.)

Options:

A.

They can be created only if OMF is enabled.

B.

They are system Generated at the time of ASM file creation.

C.

They can be used to reference existing ASM files.

D.

They are the only valid form that can be used for single file creation of a control file.

E.

An alias may be created for an existing file by referring to the fully qualified file name.

Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.