50 Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Practice Questions: Question Bank 2025

You are installing Oracle Grid Infrastructure for a standalone server. Which component is responsible for managing the automatic restart of the Oracle database instance if it fails?

Which ASM disk group redundancy level requires a minimum of three failure groups to maintain data availability if one failure group becomes unavailable?

A DBA needs to add a new voting disk to an existing ASM disk group in a RAC environment. Which command should be used to accomplish this task?

In a RAC environment, which background process is responsible for synchronizing the System Change Numbers (SCNs) across all instances to ensure read consistency?

You need to create a new ASM disk group for storing database files. The storage administrator has provided 10 disks, each 100GB in size. You want to configure the disk group for normal redundancy. What is the usable storage capacity you can expect?

A RAC database is experiencing performance issues. Upon investigation, you discover excessive Global Cache (GC) waits. Which configuration change would most effectively reduce these waits?

During a Grid Infrastructure installation, which network type is specifically designed for the RAC interconnect and should provide the highest bandwidth and lowest latency?

Your organization needs to perform maintenance on the storage array hosting an ASM disk group. Which ASM feature allows you to safely take disks offline temporarily while maintaining data accessibility?

In a four-node RAC cluster, you notice that node evictions are occurring intermittently. Investigation reveals that the cluster interconnect shows occasional latency spikes. You need to implement a solution that prevents unnecessary node evictions while the network issue is being resolved. What should you configure?

You are implementing a policy-managed RAC database with server pools. The application requires that at least two database instances are always running, and can scale up to four instances during peak hours. How should you configure the server pools?

Your organization is planning to implement Oracle ASM for storage management. Which statement accurately describes ASM disk group compatibility attributes?

A DBA needs to add a new voting disk to an existing Oracle Clusterware configuration. Which command should be used to accomplish this task?

During a RAC database maintenance window, you need to relocate a running service from one instance to another without disconnecting current sessions. Which srvctl command option should you use?

An administrator notices that ASM rebalance operations are taking longer than expected after adding disks to a disk group. Which ASM parameter controls the speed of rebalance operations and what is its valid range?

Your RAC database is experiencing performance issues. After investigation, you discover excessive interconnect traffic. Which Oracle feature specifically reduces interconnect traffic by maintaining separate buffer caches on each instance?

A database administrator needs to perform rolling patches on a RAC cluster with minimal downtime. Which Oracle feature enables this capability?

You are troubleshooting network connectivity issues in your RAC cluster. Which command will display the current status of all network interfaces used by Grid Infrastructure, including public, private, and ASM networks?

An organization wants to implement ASM Filter Driver (ASMFD) instead of ASMLib. What is the primary advantage of using ASMFD over ASMLib?

A production RAC database has four instances. You need to configure a service that runs on only two specific instances under normal conditions but can failover to the other instances if needed. Which service configuration approach should you use?

After a node eviction in your RAC cluster, you need to identify the root cause. Which Grid Infrastructure log file should you examine first to understand why the node was evicted?

An administrator needs to add a new voting disk to an existing ASM diskgroup that currently stores voting files. Which command should be used to accomplish this task?

Which background process in an ASM instance is responsible for coordinating rebalance operations when disks are added or removed from a diskgroup?

A RAC database is experiencing performance issues during peak load. Investigation shows that some application SQL statements are executing on only one instance while other instances remain underutilized. What is the most likely cause and solution?

During a rolling upgrade of Grid Infrastructure, which component must be upgraded first before upgrading the Oracle Database homes?

An administrator is troubleshooting intermittent node evictions in a four-node RAC cluster. The cluster health monitor shows network heartbeat misses during these events. Which diagnostic tool would provide the most comprehensive analysis of the interconnect performance and help identify the root cause?

Which ASM attribute determines how many disk failures a diskgroup can tolerate without losing data?

A database administrator needs to perform maintenance on the private interconnect network. The cluster has redundant interconnect paths configured. What is the correct approach to safely take one interconnect offline without impacting database operations?

In a RAC environment, which view should be queried to identify the current master node for global cache coordination of a specific data block?

An organization is implementing policy-managed databases in their RAC cluster. They want to ensure that a specific set of database services always run on exactly three instances regardless of cluster size. How should this be configured?

A critical production RAC database experiences a split-brain scenario where network partitioning causes communication loss between nodes. What mechanism does Oracle Clusterware use to resolve this situation and ensure data integrity?

Your organization is implementing Oracle RAC and needs to ensure that application connections are automatically redirected during planned maintenance. Which Oracle Net Services feature should you configure to achieve this?

An administrator needs to add a new disk to an existing ASM disk group that currently uses NORMAL redundancy. The disk group has disks in two failure groups. What happens when the new disk is added without specifying a failure group?

A database administrator notices that one RAC instance is receiving significantly more connections than others, causing performance issues. The application uses a SCAN listener for connections. What is the most likely cause of this imbalance?

During Grid Infrastructure installation, the installer fails with an error indicating that the voting disk cannot be created. Which prerequisite was most likely not met?

You are performing an online rebalance operation on an ASM disk group after adding new disks. The operation is taking longer than expected. Which ASM initialization parameter can you modify to speed up the rebalance without requiring an instance restart?

A company is planning a RAC deployment and wants to minimize the impact of network failures. Which network configuration best practice should they implement?

An administrator needs to perform maintenance on ASM disks in a NORMAL redundancy disk group. Before beginning, they want to verify that the disk group can tolerate a disk failure. Which query should they run to check the redundancy status?

In a four-node RAC cluster, you need to configure a service that runs on only two specific nodes under normal circumstances but can failover to any available node if both preferred nodes fail. Which srvctl command accomplishes this?

After a node unexpectedly reboots in a RAC cluster, you notice that the node successfully rejoins the cluster but applications are experiencing intermittent connection failures to that node's instance. What is the most likely cause?

Your organization uses ASM with FLEX redundancy for a disk group. A disk fails in one of the failure groups. What is the key advantage of FLEX redundancy compared to NORMAL redundancy in this scenario?

You are configuring Oracle Flex ASM for your Grid Infrastructure deployment. Which statement accurately describes the communication between database instances and ASM instances in a Flex ASM configuration?

An administrator needs to remove a node from a two-node RAC cluster for hardware replacement. What is the correct sequence of high-level steps to properly delete the node from the cluster?

You need to configure Database Resource Manager in a RAC environment to manage workload across multiple instances. Which component enables instance-specific resource allocation and management in RAC?

During a Grid Infrastructure upgrade from 18c to 19c on a four-node cluster, the upgrade fails on the third node. What is the recommended approach to resolve this situation?

You are configuring ASM disk groups and need to choose between NORMAL and HIGH redundancy. Your storage array already provides RAID protection. What is the best practice recommendation?

In a RAC environment, you notice that a particular service is frequently relocating between instances, causing connection disruptions. Which parameter should you adjust to prevent excessive service relocation?

You need to perform maintenance on the voting disk location in ASM. Which statement is true about voting disk management in Oracle Grid Infrastructure 19c?

After a network disruption in your RAC cluster, you find that database connections are hanging. Checking the alert log, you see messages about DRM (Dynamic Resource Mastering) operations. What is the most likely cause?

You want to configure Transparent Application Continuity (TAC) for your RAC database. Which prerequisite must be met for TAC to function properly?

An ASM instance fails to start with an error indicating insufficient memory. You need to adjust ASM instance memory parameters. Which parameter specifically controls the memory allocated to the ASM instance?