Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

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


364 Students Passed

94% Average Score

94% Same Questions
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

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.

Questions # 2:

Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)

Options:

A.

It is uniformly available on all instances for administrator-managed databases.

B.

It cannot be used to automate the opening of the PDB by the Clusterware.

C.

It is automatically registered in the OCR.

D.

It is created and started on only one instance when using policy-managed database configuration.

E.

It is not automatically registered in the OCR.

Questions # 3:

Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)

Options:

A.

It can analyze performance over any given time period.

B.

It can diagnose skew in response time.

C.

It can analyze performance using data captured on all instances.

D.

It can only analyze performance on the instance running the ADDM job.

E.

It can diagnose latency problems in the Cluster Interconnect.

F.

It runs automatically in Instance ADDM mode after each AWR snapshot is created.

Questions # 4:

Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

Options:

A.

Each cluster node must have at least two network interface cards.

B.

You must enable the Name Server Cache Daemon

C.

A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.

D.

A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

E.

DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.

F.

You must create a Grid Management Repository database.

Questions # 5:

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.

Questions # 6:

Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

Options:

A.

An application VIP is created on the default network by the appvipcfg utility.

B.

Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

C.

If an application sends messages to be displayed and sets the display variable, then an application VIP is required.

D.

An application VIP can be created with the crsccl utility.

E.

An application VIP is created on the interconnect network by the crsccl utility.

Questions # 7:

Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

Options:

A.

Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.

B.

Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.

C.

Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.

D.

To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.

E.

To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.

Questions # 8:

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)

Options:

A.

Use the crsct1 set trace res "resource_name=debugging_level" command.

B.

Use the crsct1 set log res "resource_name=debugging_level2" command.

C.

Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

D.

Use the cluvfy comp command for the specific resource within a component.

Questions # 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.

Questions # 10:

Examine this command:

Question # 10

Which two statements are required for this command to succeed? (Choose two.)

Options:

A.

The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

B.

newtemplate must be defined for the +DATA disk group.

C.

Existing data files in TBS1 must also use the same template.

D.

User-defined subdirectories ORCL and USERS must already exist.

E.

The +DATA disk group should not be part of Flex ASM.

Viewing page 1 out of 3 pages
Viewing questions 1-10 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.