Oracle 1z0-078 Value Pack (Frequently Bought Together)

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)

• A. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
• B. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
• C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
• D. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
• E. Clusterware will monitor the service while it is active.

A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible.
Which feature will support this requirement?

• A. Fast Connection Failover (FCF)
• B. Transparent Application Failover (TAF)
• C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
• D. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

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

• A. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
• B. Only one ADVM volume can be created in an ASM disk group.
• C. File systems contained in ADVM volumes may only contain database files.
• D. An ADVM volume is individually named and can contain only one file system.
• E. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

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

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

Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)

• A. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
• B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
• C. When a policy is first created, it is initially active.
• D. An administrator-defined policy may be activated using the srvctl utility.
• E. When a policy is first created, it is initially inactive.
• F. When a policy is activated, resources cannot be automatically started to comply with the policy definition.