Home
Oracle
1Z0-078 Exam Questions

Oracle 1Z0-078 Practice Exam Questions & Answers

7 Free Questions Last reviewed October 28, 2026 Prepared & Reviewed by the ValidExamDumps Editorial Team

Exam details Free questions Study guide FAQ

77 Practice Questions (Our Bank)

120 minutes Exam Duration

68% Passing Score

USD 245 Official Exam Fee (United States)

Exam Facts

Oracle 1Z0-078 Exam Details

Key details for this exam, checked against the published exam outline

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
Full Question Set: 77 questions Get All Questions

Practice Questions

Free 1Z0-078 Practice Questions

Each question shows the correct answer and an explanation of why it is right

ValidExamDumps Editorial Team Every question and its answer is checked by our 1Z0-078 exam preparation team, who also write the explanation shown with each one. How we research and review these pages

Question 1 Domain 13 Managing Oracle RAC One Node

Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

AEach cluster node must have at least two network interface cards.

BYou must enable the Name Server Cache Daemon

CA DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.

DA DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

EDNS must be configured to delegate name resolution for the cluster subdomain to the cluster.

FYou must create a Grid Management Repository database.

Correct Answer B, D, E

Explanation Converting a single-instance database to RAC requires moving data to shared storage and then configuring multiple instances to access it. DBCA is the tool designed to perform this migration, as it handles the necessary changes to the database configuration, initialization parameters, and cluster settings. Other approaches like manual migration or using SQL scripts would not properly configure the cluster-aware components needed for RAC operation.

Question 2 Domain 20 Making Applications Highly Available with Oracle Clusterware

Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?

AUsing the rconfig utility to migrate the database to shared storage and then using dbca to start one or more RAC database instances on the cluster

BUsing dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster

CUsing the rconfig utility to create a template from the single-instance database and then using dbca to create a RAC database on the cluster using that template

DUsing dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template

Correct Answer B

Explanation Policy sets in Oracle Clusterware control how server pools are managed when user-defined policy management is enabled. All server pools in a cluster come under the control of a single policy set when this feature is active. A server pool can have different attribute values assigned for different policies within that same policy set, allowing flexibility in resource allocation. The statements about policy sets controlling all server pools and allowing different attributes per policy are correct administrative facts about Clusterware policy-based management.

Question 3 Domain 19 Grid Infrastructure Installation

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 The OCRCHECK utility can validate the Oracle Local Registry (OLR) while the cluster is running on all nodes without requiring the cluster to stop. The OCRDUMP utility can extract specific keys from both the OLR and OCR (Oracle Cluster Registry) in an online fashion while clusterware remains active. These diagnostic tools allow administrators to inspect and validate cluster configuration files without disrupting cluster operations. Both utilities support online diagnostics, which is essential for maintaining cluster availability during troubleshooting.

Get the complete 1Z0-078 question set $20~~$40~~

Get Full Access

Question 4 Domain 19 Grid Infrastructure Installation

Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

Assh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.

BGrid Infrastructure must be installed on all cluster nodes.

CThe Clusterware stack must be up on all cluster nodes.

DThe Clusterware stack must be up on all cluster nodes where the Database software will be installed.

ESSH user equivalence for the Oracle software owner must be configured on all cluster nodes.

FGrid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

Correct Answer A, B

Explanation Oracle Grid Infrastructure 19c automatically enables Secure Cluster Communication as part of new installations and upgrades without requiring manual configuration. This feature uses TLS, message digest mechanisms, and fuzzing protection to secure cluster interconnect traffic. Administrators do not need to perform additional steps to activate this security feature because it is enabled by default. The automatic implementation ensures that cluster communication is protected from the start without adding configuration complexity.

Question 5 Domain 10 Managing High Availability of Services

Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

AThe Grid Infrastructure Management Repository is only required when using ASM.

BSpecifying the use of Grid Naming Service is optional.

CNormal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of

DThe Clusterware binaries may be installed without installing ASM binaries.

EHigh Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

Correct Answer B, C

Explanation The colocation_tag parameter controls where clients are routed when connecting to a service in RAC. When clients have the same colocation_tag value, the system routes them to the same instance that is running that service whenever possible. This feature improves performance by keeping related client connections on a single instance, reducing cross-instance communication and improving cache locality. Colocation_tag is a service attribute that enables application-aware routing and better resource utilization in RAC environments.

Question 6 Domain 16 Administering ASM Files, Directories and Templates

Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

AOracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.

BOracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.

COracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.

DTo enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.

ETo enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.

Correct Answer A, E

Explanation Creating a new ASM file template requires that the template itself be predefined for the target disk group before you can use it in a command. Additionally, if the command references user-defined subdirectories like ORCL and USERS, those directories must already exist within the ASM disk group structure. The command cannot create these prerequisites automatically, so they must be in place beforehand. Both the template definition and the subdirectory structure must be established before executing the file creation command.

Question 7 Domain 9 RAC Database Monitoring and Tuning

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

AGlobal Enqueues and Instance Locks replace mutexes completely in RAC database instances.

BGlobal Enqueues may have converters and waiters in the same instance.

CGlobal Enqueues may have owners and waiters in the same instance.

DGlobal Enqueues and Instance Locks replace latches completely in RAC database instances.

EIn a RAC database, there is no LMDO process if only one instance is running.

FIn a RAC One Node database, there is no LMD) process if only one instance is running.

Correct Answer C, E

Explanation ADDM in a RAC environment can examine performance data across any time period that you specify, not just predefined intervals. It can detect response time skew, which means identifying when some instances respond faster than others in the cluster. ADDM collects and analyzes diagnostic data from all instances in the cluster to provide a comprehensive view of system performance. These capabilities make ADDM valuable for identifying RAC-specific bottlenecks and imbalances that occur across multiple cluster nodes.

Full Access

Get the complete 1Z0-078 question set

Starting from 50% OFF

$20 ~~$40~~

77 questions covering all exam domains
Correct answers with explanations, like the free questions above
PDF and online practice test
90 days of free updates

Get Full Access

One-time paymentInstant download

Study Guide

What the Oracle 1Z0-078 Exam Covers

Exam domains verified against the Official Oracle 1Z0-078 exam guide, last checked October 2026.

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 4 RAC Databases and Architecture

Understand advantages of Oracle RAC and describe the necessity of global resources and cache coordination in clustered environments.

Domain 5 Installing and Configuring Oracle RAC

Install Oracle Database on the platform and build clusters in a database. Convert an instance in the database to RAC.

Domain 6 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 7 Managing Backup and Recovery for RAC

Configure the RAC environment for ARCHIVELOG mode. Set up fast recovery area and configure RMAN for RAC.

Domain 8 Managing Global Resources

Use global concurrency control and understand its importance. Manage the Global Resource Directory and explain instance lock management.

Domain 9 RAC Database Monitoring and Tuning

Describe RAC-specific tuning and identify RAC-specific wait events. Utilize AWR and ADDM in RAC environments.

Sample question from this domain above Q7

Domain 10 Managing High Availability of Services

Set up and administer services in the RAC environment. Utilize services with client applications and configure service tracing.

Sample question from this domain above Q5

Domain 11 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.

Domain 12 Upgrading and Patching Oracle RAC

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

Domain 13 Managing Oracle RAC One Node

Convert a RAC One Node database to a RAC database. Use DBCA to transform a single-instance database to RAC One Node.

Sample question from this domain above Q1

Domain 14 Using Oracle Database Quality of Service Management (QoS)

Explain the goals and advantages of QoS and its operation in RAC environments.

Domain 15 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 16 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 Q6

Domain 17 Administering Oracle CloudFS

Administer ASM Dynamic Volume Manager with ASM volumes. Adopt ASM Cluster File System and use ACFS snapshots.

Domain 18 Oracle CloudFS Advance Topics

Set up ACFS auditing with ACFS encryption implementation. Oversee ACFS encryption, administration, and replication.

Domain 19 Grid Infrastructure Installation

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

Sample questions from this domain above Q3 Q4

Domain 20 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 Q2

Domain 21 Automatic Storage Management (ASM) Administration Overview of ASM

This section explains the tole of the Automatic Storage Management (ASM) architecture and describes the various elements of ASM.

Domain 22 Administering ASM Instances

Explain application and starting parameters for ASM instances. Manage ASM instances and related processes.

Domain 23 FLEX ASM

Understand components and architecture of Flex ASM. Install and set up Flex ASM.

Domain 24 Administering ASM Disk Groups

Create and erase ASM disk groups. Set up features of disk groups and troubleshoot continuously.

Domain 25 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.

Domain 26 Administering Oracle CloudFS

Administer ASM Dynamic Volume Manager with ASM volumes. Adopt ASM Cluster File System and use ACFS snapshots.

Domain 27 Oracle CloudFS Advance Topics

Set up ACFS auditing with ACFS encryption implementation. Oversee ACFS encryption, administration, and replication.

FAQ

1Z0-078 Exam FAQ

Common questions about the exam itself

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.

Other Oracle Exams

Free practice questions for more Oracle certification exams

All Oracle exams

1Z0-078 Full question set $20 ~~$40~~ 50% OFF

Get Full Access