What background is needed to take the 1Z0-078 exam?

You should have hands-on experience administering Oracle databases, particularly with RAC environments, ASM storage management, and Grid Infrastructure. Most candidates have several years of Oracle DBA experience before attempting this exam.

How long does it typically take to prepare for the 1Z0-078 exam?

Preparation time varies based on your existing RAC experience, but most candidates need three to six months of focused study combined with practical lab work. If you lack RAC hands-on experience, plan for additional time.

Is 1Z0-078 harder than other Oracle DBA exams?

Yes, 1Z0-078 is considered an advanced certification. It tests understanding of interconnected systems where ASM, RAC, and Grid Infrastructure operate together, which requires both theoretical knowledge and practical troubleshooting skills.

What is the most challenging domain on the 1Z0-078 exam?

Managing Global Resources and RAC-specific tuning are typically the hardest areas because they require understanding complex interactions between instances and cache coherency protocols that have few parallels in single-instance database administration.

Can I take the 1Z0-078 exam online at home?

Yes, you can take this exam online proctored or at a Pearson VUE test centre. Online proctored exams require a stable internet connection, a quiet room, and verification of your identity through webcam.

What happens if I fail the 1Z0-078 exam?

You can retake the exam after a waiting period determined by Oracle's retake policy. Each exam attempt requires a new exam fee purchase.

How does 1Z0-078 relate to other Oracle Database 19c exams?

1Z0-078 is the advanced specialized exam for RAC, ASM, and Grid Infrastructure, separate from 1Z0-082 (Database Administration I) and 1Z0-083 (Database Administration II) which cover general DBA skills for single-instance and other database configurations.

What job roles does the 1Z0-078 certification prepare you for?

This certification qualifies you for Oracle RAC Administrator, Grid Infrastructure Administrator, or Senior Database Administrator roles, particularly in organizations running large-scale, high-availability database environments.

How long is the 1Z0-078 certification valid after I pass?

Oracle Database certifications have specific renewal requirements. You should check your certification path to understand the validity period and any continuing education or recertification requirements.

Are there multiple choice and scenario questions on 1Z0-078?

Yes, the exam includes both multiple choice and scenario-based questions designed to evaluate your practical understanding of RAC operations and your ability to configure and troubleshoot these systems.

1Z0-078 Practice Questions with Explained Answers

5 Free Questions · Last reviewed: September 14, 2026 · Prepared & Reviewed by the ValidExamDumps Editorial Team

77 Practice Questions (Our Bank)

120 minutes Exam Duration

68% Passing Score

USD 245 Exam Fee (United States)

Exam Code: 1Z0-078
Full Name: Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration
Issuing Body: Oracle
Question Format (Our Bank): Multiple Choice
Delivery: Pearson VUE testing center or online proctored

Question 1 Domain 10Managing High Availability for Connections and Applications

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

ASSH user equivalence for the Oracle user can be set up before the software installation.

BFix-up scripts generated during the installation must be run as root on UNIX platforms.

CThe software must be installed into a local file system on each node.

DThe software must be installed into a cluster file system.

ERAC installations require Oracle Enterprise Edition.

FThe software can be installed into an ACFS file system.

GThe software must be installed on all nodes in the cluster.

Correct Answer: A, B, E

Explanation Transparent Application Continuity in Oracle RAC 19c automatically recovers user sessions after instance failures without requiring application code changes or DBA intervention. It activates when the failover type is set to auto, which enables the database to replay the in-flight transaction at an alternative instance. The other options likely mention incorrect prerequisites or limitations that do not apply to how this feature actually works in RAC environments.

Question 2 Domain 11Upgrading and Patching Oracle RAC

Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

AServices support the balancing of client connections across RAC database instances.

BIn server-side load balancing, node listener redirects the client to another node listener for connection to an instance.

CLoad balancing can be done by the client or the listener, but not both, for any one connection request.

DClient-side connect-time load balancing can balance connection requests across SCAN listeners.

ELoad balancing can be done by the client, the listener, or both, for any one connection request.

Correct Answer: A, B, E

Explanation Before running OPatch to patch Oracle Grid Infrastructure 19c, you must stage the patch files on all cluster nodes. This ensures every node has access to the patch binaries before the patching process begins. Staging allows OPatch to work consistently across the cluster and prevents failures due to missing patch files on any node during the rolling patch operation.

Question 3 Domain 19Making Applications Highly Available with Oracle Clusterware

Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)

AA copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

BAn ACFS snapshot can be ACFS encrypted.

Cacfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

Dacfsucil encr on can be used to specify the encryption key length for a directory or file.

Eacfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.

Correct Answer: B, D, E

Explanation Clusterware-managed application VIPs can be created using the appvipcfg utility on the default network or using the crsctl utility for more advanced configurations. The appvipcfg utility is the standard tool for creating application VIPs, while crsctl provides command-line cluster resource control options. Other options likely describe virtual IPs incorrectly or mention tools that do not support application VIP creation.

Question 4 Domain 15Administering ASM Files, Directories and Templates

Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

AWhen possible, clients with the same colocation_tag are routed to the same instance that offers a given service.

BWhen possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.

CWhen possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.

DWhen possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.

Correct Answer: A

Explanation Fully qualified file names in ASM are system-generated when files are created and serve as permanent references to those files. You can use them to reference existing ASM files and to create aliases that point to the same underlying file. Aliases provide user-friendly names while the fully qualified name remains the technical identifier. Other options probably describe incorrect characteristics of how ASM naming works.

Question 5 Domain 10Managing High Availability for Connections and Applications

Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?

AUpdate the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory

BStage the patch on the cluster node where the OPacch utility will be executed.

CUpdate the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.

DStage the patch on all cluster nodes.

Correct Answer: D

Explanation Load balancing in RAC database services works at both client and server sides during initial connection attempts. Server-side connect time load balancing distributes connections when the server receives the request, while client-side connect time load balancing distributes them before the client sends the request to the database service. Both methods reduce connection concentration on single instances. The other options likely confuse load balancing timing or incorrectly describe where the balancing decision occurs.

Domain 1: Administering Oracle RAC

Explain redo log files and undo tablespaces in a RAC setup. Learn to turn RAC databases and parts of it on and off, and how to change starting settings in a RAC setup.

Domain 2: Database Tuning and Monitoring of RAC

Find tuning parts unique to RAC and pinpoint RAC-specific delays, queues, and stats. Apply common RAC tuning methods and utilize Cluster Database Performance tools.

Domain 3: Handling and Overseeing High Availability of Services

Set up and handle services in RAC and use services with applications. Configure service grouping and tracking for high availability.

Domain 10: Managing High Availability for Connections and Applications

Set up client-side connect-time load balancing and server side failover. Use Load Balancing Advisory and Fast Application Notification.

Sample questions from this domain above: Q1 Q5

Domain 11: Upgrading and Patching Oracle RAC

Plan rolling patches and updates. Install patchsets using Universal Installer and patches using opatch utility.

Sample question from this domain above: Q2

Domain 14: Using Multitenant Architecture in a RAC Environment

Explain multitenant architecture in RAC and non-RAC setups. Create a multitenant container database in a RAC environment and set up pluggable databases.

Domain 15: Administering ASM Files, Directories and Templates

Use client utilities for accessing ASM files. Create and administer ASM files, directories, and aliases, and configure disk group templates.

Sample question from this domain above: Q4

Domain 18: Grid Infrastructure Installation

Understand cluster concepts and Oracle Clusterware architecture including flex cluster. Complete grid infrastructure installation and administer cluster nodes.

Domain 19: Making Applications Highly Available with Oracle Clusterware

Explain availability components of Clusterware and policy-based management. Create Virtual IPs and oversee application resources.

Sample question from this domain above: Q3

Oracle 1Z0-078 Practice Exam Questions & Answers

Oracle 1Z0-078 Exam Details

Free 1Z0-078 Practice Questions

What the Oracle 1Z0-078 Exam Covers

1Z0-078 Exam FAQ