Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Practice Exam 2025: Latest Questions

You are installing Oracle Grid Infrastructure 19c for a new RAC cluster. During the installation, you need to specify the SCAN (Single Client Access Name). What is the recommended number of SCAN VIP addresses for a production RAC cluster?

In an ASM disk group, you need to change the redundancy level from NORMAL to HIGH for critical database files. What is the correct approach to accomplish this?

A database administrator notices that one instance in a four-node RAC cluster is experiencing high interconnect latency. Which tool should be used first to diagnose interconnect performance issues?

You are configuring services for a RAC database that supports both OLTP and reporting workloads. The reporting workload should only run on instances 3 and 4, while OLTP should run on instances 1 and 2, with failover capability to instances 3 and 4. How should you configure the reporting service?

During Grid Infrastructure installation, which component is responsible for maintaining cluster membership information and node eviction when a node fails to communicate?

An ASM instance is running with an ASM disk group that has COMPATIBLE.RDBMS set to 19.0.0.0 and COMPATIBLE.ASM set to 19.0.0.0. The DBA wants to downgrade the database to version 12.2. What must be done to support this downgrade?

In a RAC environment, applications are experiencing delays during instance failure. You need to configure Fast Application Notification (FAN) to improve failover time. Which component must be configured on the application tier to receive FAN events?

You are troubleshooting a RAC database where users report intermittent slow performance. Upon investigation, you find high 'gc buffer busy acquire' and 'gc buffer busy release' wait events. What is the most likely cause and recommended solution?

When adding a new node to an existing RAC cluster, which sequence of operations is correct?

An ASM disk group is configured with EXTERNAL redundancy and contains 10 disks. One disk fails. What is the expected behavior of ASM and the databases using this disk group?

Your organization is planning to implement ASM for storage management in a RAC environment. Which component is responsible for coordinating the rebalancing operations when a disk group configuration changes?

An application requires a service that should run on only one instance at a time in a four-node RAC cluster, but should automatically relocate to another instance if the current instance fails. Which service configuration should you implement?

During a Grid Infrastructure upgrade, you notice that the OCR backup location is almost full. What is the default retention policy for automatic OCR backups?

You are troubleshooting connection storms in your RAC database where multiple application servers simultaneously attempt to create connections after a network outage. Which combination of features would best mitigate this issue?

Your ASM disk group DATA is configured with NORMAL redundancy and has three failure groups. One disk in a failure group fails. What happens to the disk group?

A database administrator needs to add a new voting disk to the cluster. The current voting disk configuration uses ASM disk group GRID with NORMAL redundancy. What is the correct approach?

You need to perform maintenance on one node of a four-node RAC cluster without impacting database availability. Which sequence of commands properly prepares the node for maintenance?

What is the purpose of the ASM Cluster File System (ACFS) feature in Grid Infrastructure?

In a RAC environment, you observe that transactions on one instance are frequently waiting for blocks that are being modified on another instance. The wait event 'gc current block busy' appears frequently in AWR reports. Which RAC-specific tuning approach would most directly address this issue?

You are configuring ASM disk groups and need to decide on the allocation unit (AU) size. Which statement accurately describes the impact of AU size selection?

Your organization is planning to implement Oracle Flex ASM in a Grid Infrastructure environment. Which statement accurately describes a key characteristic of Oracle Flex ASM architecture?

During a planned maintenance window, you need to patch the Oracle Grid Infrastructure on a two-node RAC cluster. Which patching method allows you to apply patches with minimal downtime by patching one node at a time while the other continues to service requests?

You are configuring Oracle Cluster Registry (OCR) redundancy for a production RAC environment. The cluster currently has a single OCR location. What is the Oracle recommended best practice for OCR redundancy to ensure high availability?

An application team reports that their batch job is experiencing inconsistent performance across different instances in your four-node RAC database. You want to configure services to ensure that the batch job workload runs only on two specific nodes (nodes 3 and 4) while OLTP workload runs on nodes 1 and 2. Which approach correctly implements this workload segregation?

You are troubleshooting a RAC database where users report intermittent connection failures. Upon investigation, you discover that the SCAN listeners are not properly distributing connections across all available instances. The SCAN is configured with three IP addresses. Which diagnostic step would be MOST effective in identifying the root cause of this issue?