Oracle Database Administration 2019 Certified Professional — Question 28

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.)

Answer options

• A. High availability for the CRM service
• B. Load balancing of connection requests across all six database instances
• C. High availability for the ERP service
• 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 client connection requests for ERP across three Single Client Access Name (SCAN) listeners
• G. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool

Correct answer: A, C, F, G

Explanation

The correct answers A, C, F, and G highlight the high availability and load balancing features provided by Oracle 19c for the services configured. Options B and E are incorrect as they do not apply to the specific policy-managed configurations of CRM and ERP in this context, and load balancing for ERP cannot leverage all instances in the prod pool as it is a singleton service.