Free Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Practice Test

You are installing Oracle Grid Infrastructure for a standalone server. Which component is responsible for managing the automatic restart of the Oracle database and listener after a server reboot?

During Grid Infrastructure installation, you need to configure the SCAN (Single Client Access Name) for your RAC cluster. What is the minimum number of IP addresses that should be configured for SCAN to provide high availability?

A database administrator needs to create a new ASM disk group with high redundancy. The environment has 12 disk devices available across 3 failure groups. What is the minimum number of failure groups required to create a HIGH redundancy disk group?

You are troubleshooting connectivity issues in a RAC database. A client application is experiencing intermittent connection failures. Which view should you query to determine which SCAN listener is handling the most connections and identify potential load balancing issues?

An organization is planning a Grid Infrastructure installation for a 4-node RAC cluster. Which network type is mandatory for proper cluster communication and heartbeat management?

You need to add a new disk to an existing ASM disk group named DATA. The disk group currently uses NORMAL redundancy. What happens to the data in the disk group when you add the new disk?

In a RAC environment, which background process is primarily responsible for coordinating the Global Cache Service and managing block transfers between instances?

A critical disk in an ASM disk group with NORMAL redundancy has failed. What is the default time window before ASM automatically drops the failed disk and begins full rebalancing?

You are configuring services for a RAC database to support an OLTP application that requires high availability and connection load balancing. Which service management option should you use to ensure connections are automatically redistributed when an instance fails?

During a Grid Infrastructure upgrade, the root.sh script fails on the second node of a two-node cluster. What is the recommended first step to resolve this issue?

Which Oracle Clusterware component is responsible for managing the voting disk and maintaining cluster membership information?

In an ASM environment, you want to ensure that specific files are stored with different redundancy levels within the same disk group. Which ASM feature allows you to override the default disk group redundancy for individual files?

You need to relocate a RAC database service from one preferred instance to another for maintenance. Which SRVCTL command should you use?

A RAC database is experiencing performance issues. You notice high 'gc buffer busy acquire' wait events. What is the most likely cause of this issue?

What is the purpose of the Oracle Cluster Registry (OCR) in a Grid Infrastructure environment?

An ASM instance is running on a server with limited memory. You need to optimize ASM instance memory usage. Which initialization parameter specifically controls the maximum memory that ASM can use for managing disk group metadata?

You are configuring policy-managed databases in a RAC cluster with server pools. Which of the following statements about server pools is accurate?

During maintenance, you need to stop all resources running on a specific node in a RAC cluster without affecting other nodes. Which command accomplishes this task?

You are implementing ASM Filter Driver (ASMFD) in your environment. What is the primary advantage of using ASMFD over ASMLib?

After a network interruption, you notice that one node in your RAC cluster has been evicted. Which log file should you examine first to determine the reason for the node eviction?