Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Free Sample Questions

Description

Covers installing and administering Oracle RAC, global resource and service availability, Grid Infrastructure and Clusterware installation, cluster node and policy management, and ASM administration.

20 free sample questions208 in the full practice test

Try simulator

1Z0-078 Sample Questions

  1. Question 1

    Intermediate

    Troubleshooting Oracle Clusterware · Policy-Based Cluster Management Troubleshooting

    A junior DBA reports that a critical application resource app_vip failed to relocate to node2 after node1 was shut down for maintenance. The resource is configured with PLACEMENT=favored. The junior DBA has already verified network connectivity. As the senior administrator, you investigate the cluster alert log and find the message CRS-2527: Unable to start 'app_vip' on 'node2' because it is a member of server pool 'Generic' which is not active on that server. What is the most likely root cause and the correct resolution?

    Answer and explanation

    Correct answer: C

    The error message CRS-2527 explicitly states the server pool is not active on the target server. In a policy-managed cluster, resources are tied to server pools. If a server is not part of a pool's server list, the pool cannot be active there, and consequently, its member resources cannot start. The most direct resolution is to add the target node to the server pool's list of candidate servers using srvctl modify serverpool.

  2. Question 2

    AdvancedMultiple answers

    Managing Global Resources · Global Resource Contention Tuning

    A financial services company is experiencing significant performance degradation in their 4-node RAC cluster during end-of-quarter processing. An AWR report shows high gc cr block busy and gc current block busy wait events, concentrated on a single table used for transaction logging. The application uses sequences for primary key generation. Which TWO of the following strategies are most effective for mitigating this specific type of global cache contention? (Select TWO)

    Answer and explanation

    Correct answers: B, D

    Hash partitioning distributes DML across different partitions and their underlying index segments, effectively spreading out the 'hot spots' and reducing contention on a single index leaf block.

    Using a large sequence cache with NOORDER allows each instance to have its own range of sequence values. This prevents all instances from competing for and inserting into the same right-hand index leaf block, which is a classic cause of 'gc current block busy' waits.

  3. Question 3

    Beginner

    RAC Databases and Architecture · Global Cache Coordination

    In the context of Oracle RAC, what is the primary function of Cache Fusion?

    Answer and explanation

    Correct answer: B

    Cache Fusion is the core technology of RAC that enables instances to share data without writing it to disk first. It uses the high-speed private interconnect to ship data blocks from one instance's buffer cache to another's, satisfying read or write requests much faster than a disk I/O operation would. This process is managed by the Global Cache Service (GCS).

  4. Question 4

    Beginner

    Administering Oracle RAC · Undo Tablespaces in RAC

    True or False: In a 4-node Oracle RAC 19c database, each instance must have its own dedicated UNDO tablespace, and these tablespaces must reside on shared storage.

    Answer and explanation

    Correct answer: A

    This is a fundamental architectural requirement for Oracle RAC. Each instance manages its own transactions and requires its own UNDO tablespace. Because any instance may need to perform recovery on a transaction initiated by another (failed) instance, all UNDO tablespaces must be on shared storage accessible to all nodes in the cluster.

  5. Question 5

    Intermediate

    Managing High Availability for Connections and Applications · Transparent Application Continuity

    You are configuring a critical service named OLTP_SVC for a 3-node RAC cluster. The requirement is that in the event of an unplanned instance failure, any in-flight transactions for connected sessions must be recovered automatically without interrupting the end-user application. The application is a modern Java application using a UCP connection pool. Which Oracle high-availability feature should be configured for the OLTP_SVC service to meet this requirement?

    Answer and explanation

    Correct answer: C

    The key requirement is the recovery of in-flight transactions without user interruption. This is the precise function of Application Continuity (AC). AC records the session and transactional state, allowing it to be replayed on a surviving instance after a failure, making the outage transparent to the application. TAF is an older technology that primarily replays SELECT statements and does not recover the full transactional state.

  6. Question 6

    IntermediateMultiple answers

    Administering ASM Disk Groups · ASM Rebalance Operations

    An ASM administrator needs to add three new disks of the same size to an existing +DATA disk group that currently has Normal Redundancy. The administrator wants to ensure the rebalance operation completes as quickly as possible without impacting the foreground database workload significantly. Which three actions or settings are relevant to achieving this goal? (Select THREE)

    Answer and explanation

    Correct answers: A, C, F

    This allows the administrator to control exactly when the I/O-intensive rebalance operation occurs, minimizing impact on the workload by running it during off-peak hours.

    Proper failure group design is crucial for ASM's striping and mirroring. Adding disks to a new failure group (or distributing them among existing ones) is necessary for ASM to maintain redundancy and balance data correctly.

    The goal is a balance between speed and workload impact. POWER 1 is too slow. A very high power would impact the workload too much. A moderate power like 4 is a common choice to make good progress without causing severe performance degradation.

  7. Question 7

    Intermediate

    Troubleshooting Oracle Clusterware · Cluster Startup Issues

    A 2-node cluster is not starting correctly after a full power outage. On node1, the administrator runs crsctl check crs and sees all services online. However, on node2, the same command shows Cluster Ready Services (CRS) as offline. The administrator examines the CSSD log file on node2 and finds repeated entries indicating "No communication with master node" and "Waiting for voting disk access".

    Based on the provided diagram of a standard clusterware architecture and the symptoms described, what is the most probable cause of the failure on node2?

    graph TD subgraph Shared_Storage OCR VotingDisks[(Voting Disks)] end subgraph Node1 OHASD1[OHASD] --> CSSD1[CSSD] CSSD1 --> CRSD1[CRSD] CRSD1 --> OCR CSSD1 --> VotingDisks end subgraph Node2 OHASD2[OHASD] --> CSSD2[CSSD] CSSD2 --> CRSD2[CRSD] CRSD2 --> OCR CSSD2 --> VotingDisks end CSSD1 |Interconnect| CSSD2

    Answer and explanation

    Correct answer: C

    The Cluster Synchronization Services Daemon (CSSD) is responsible for cluster integrity and node membership, which requires access to voting disks. The log message "Waiting for voting disk access" is the key indicator. Since CSSD on node1 is online, it has successfully accessed the voting disks. The failure of CSSD on node2 to come online, combined with the log message, strongly points to a loss of connectivity from node2 to the shared storage where the voting disks reside.

  8. Question 8

    Intermediate

    Flex Clusters · Flex Cluster Architecture and Deployment

    You are managing a 6-node Flex Cluster. Three nodes are configured as Hub Nodes and three as Leaf Nodes. A new, read-intensive database will be deployed. The business requires that this database be highly available, but they want to minimize the overhead on the cluster interconnect. How should you deploy this new database?

    Answer and explanation

    Correct answer: A

    This is a primary use case for Flex Clusters. Leaf Nodes can host database instances but do not require direct access to storage. They connect to ASM instances running on Hub Nodes over the ASM network. This reduces storage network traffic and is ideal for scalable, read-intensive workloads where direct, high-bandwidth storage access from every node is not critical.

  9. Question 9

    Intermediate

    Using Multitenant Architecture in a RAC Environment · PDB Services and Server Pools

    A new pluggable database (PDB), PDB_HR, was created in a 4-node RAC container database (CDB). The business requirement is to ensure that PDB_HR can only be opened on racnode03 and racnode04. What is the most effective method to enforce this placement policy?

    Answer and explanation

    Correct answer: A

    The correct way to control PDB placement and workload in RAC is through services and server pools. By creating a server pool with only the desired nodes and then creating a service for the PDB that is assigned to that pool, you ensure that connections to that PDB (via the service) are routed only to the specified nodes, and the PDB will only be active on nodes within its assigned pool.

  10. Question 10

    Advanced

    Upgrading and Patching Grid Infrastructure · Zero-Downtime Oracle Grid Infrastructure Patching

    You are tasked with performing a zero-downtime patch of the Grid Infrastructure home on a 4-node RAC cluster. You have already provisioned a new, patched Grid Home on all nodes. What opatchauto command switch is essential for orchestrating this out-of-place, zero-downtime patching process?

    Answer and explanation

    Correct answer: D

    The zero-downtime patching process involves multiple phases. First, opatchauto apply -prepare-clone is used to prepare the new home. After this is done on all nodes, opatchauto apply -deploy-clone is run. This command performs the switchover by stopping the old GI stack and starting the new, patched GI stack in a rolling fashion across the cluster, ensuring the cluster remains operational throughout the process.

Register free for 10 more questions

Or unlock all 208 1Z0-078 questions with explanations, timed mode and flashcards.