Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

1z0-078 Exam Dumps - Oracle Certification Questions and Answers

Question # 4

You performed these steps to disable an ADVM volume containing an ACFS file system:

1. Dismount the file system.

2. Disable the volume with the ASMCMDvoldisablecommand.

Which two statements are true regarding the actions performed? (Choose two.)

Options:

A.

The ACFS file system will be permanently removed from the volume.

B.

The ACFS mount registry with Oracle restart is automatically deleted.

C.

The disabling of volume does not destroy data in the file system.

D.

The volume can be enabled and the file system can be mounted back again to access the existing data.

E.

The ACFS file system will be permanently removed from the volume only if the file system is empty.

Buy Now
Question # 5

A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.

TheCOMPATIBLE.ASM,COMPATIBLE.RDBMS, andCOMPATIBLE.ADVMparameters are currently set to 11.2 for all diskgroups..

You must support these capabilities in all diskgroups:

1. ACFS Replication

2. ACFS Encryption

To what minimum values must the compatible attributes be set?

Options:

A.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.

B.

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.

C.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1

D.

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.

E.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.

Buy Now
Question # 6

Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.

Which statement is true about securing cluster interconnect communication?

Options:

A.

Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.

B.

Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.

C.

Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.

D.

Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.

E.

Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.

Buy Now
Question # 7

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)

Buy Now
Question # 8

Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)

Options:

A.

an application VIP

B.

A Server Pool

C.

a resource dependency definition

D.

an application resource

E.

a script agent

Buy Now
Question # 9

Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)

Options:

A.

Each hub node must be connected to storage shared across all hub nodes.

B.

Each leaf node must be connected to storage shared across all cluster nodes.

C.

Each leaf node must be connected to storage shared across all leaf nodes.

D.

Leaf nodes require direct access to the voting disks.

E.

Hub nodes require direct access to the OCR file.

F.

Hub nodes require direct access to the voting disks.

Buy Now
Question # 10

Which two statements are true aboutv$asm-views in a clustered environment? (Choose two.)

Options:

A.

They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.

B.

Their names can be seen inv$fixed_tablewhen connected to an instance of any type that is started.

C.

Their names can be seen in dice when connected to an ASM instance.

D.

gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

E.

They exist in both ASM and RDBMS instances, and display the same output.

Buy Now
Question # 11

Examine these descriptions of ASM instance shutdown behavior:

1) The ASM instance shuts down immediately without an orderly dismount of disk groups.

2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.

3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.

Which two lists are correct matches for these descriptions? (Choose two.)

Options:

A.

2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

B.

2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

C.

3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

D.

3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

E.

3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Buy Now
Question # 12

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.

Buy Now
Question # 13

Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

Options:

A.

An ADVM volume is individually named and can contain only one file system.

B.

ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

C.

File systems contained in ADVM volumes may only contain database files.

D.

Only one ADVM volume can be created in an ASM disk group.

E.

To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

Buy Now
Exam Code: 1z0-078
Exam Name: Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
Last Update: Mar 29, 2025
Questions: 77
1z0-078 pdf

1z0-078 PDF

$25.5  $84.99
1z0-078 Engine

1z0-078 Testing Engine

$28.5  $94.99
1z0-078 PDF + Engine

1z0-078 PDF + Testing Engine

$40.5  $134.99