1Z0-078 Free Sample Questions

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?

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)

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

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.

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?

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)

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`? ```mermaid 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 ```

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?

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?

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?