Free Oracle 1z0-078 Exam Dumps Questions & Answers

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

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

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

• A.  Global Enqueues and Instance Locks replace latches completely in RAC database instances.
• B.  In a RAC One Node database, there is no LMD) process if only one instance is running.
• C.  In a RAC database, there is no LMDO process if only one instance is running.
• D.  Global Enqueues may have owners and waiters in the same instance.
• E.  Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
• F.  Global Enqueues may have converters and waiters in the same instance.

Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)

• A.  Resource dependencies are automatically set when using a policy-managed resource.
• B.  An administrator-managed resource can be started manually using crsct1.
• C.  A policy-managed resource can be started manually using srvct1.
• D.  A policy-managed resource can be started manually using crsct1.
• E.  An administrator-managed resource can be started manually using srvct1.
• F.  The action script is automatically set when using a policy-managed resource.

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

• A.  In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
• B.  A mixture of automatic undo management and manual undo management is supported within a RAC database.
• C.  You can dynamically assign a newly created undo tablespace to an instance.
• D.  An instance that performs instance recovery can write to the undo tablespace of a failed instance.
• E.  It is necessary to assign a specific undo tablespace to a specific instance.