Question 1 of 30
In a scenario where a company is deploying an Oracle RAC environment to support a critical application, the DBA is tasked with configuring cluster resources to ensure high availability. The DBA must ensure that the database service is properly associated with the instances and that failover mechanisms are in place. Which approach should the DBA take to achieve optimal configuration of these cluster resources?
Configure the database service with instance affinity and set up a failover policy that allows automatic relocation to another instance in case of failure.
Create multiple database services without specifying instance affinity, allowing any instance to handle requests without failover considerations.
Set up a single database service that is tied to all instances but does not implement any failover mechanisms, relying on manual intervention for recovery.
Establish instance affinity for the database service but disable automatic relocation, requiring manual intervention for any instance failures.

Preparing for Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free