Online Access Free 1z0-078 Exam Questions

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

• A.It is not automatically registered in the OCR.
• B.It is automatically registered in the OCR.
• C.It cannot be used to automate the opening of the PDB by the Clusterware.
• D.It is uniformly available on all instances for administrator-managed databases.
• E.It is created and started on only one instance when using policy-managed database configuration.

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 ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

• A.The disabling of volume does not destroy data in the file system.
• B.The volume can be enabled and the file system can be mounted back again to access the existing data.
• C.The ACFS file system will be permanently removed from the volume only if the file system is empty.
• D.The ACFS mount registry with Oracle restart is automatically deleted.
• E.The ACFS file system will be permanently removed from the volume.

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

• A.Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory
• B.Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.
• C.Stage the patch on the cluster node where the OPacch utility will be executed.
• D.Stage the patch on all cluster nodes.

Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

• A.New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
• B.Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
• C.The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
• D.New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-

You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

• A.High availability for the ERP service
• B.Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
• C.Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
• D.Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
• E.Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
• F.Load balancing of connection requests across all six database instances
• G.High availability for the CRM service