PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free Oracle 1Z0-078 Practice Questions

Pass your Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Oracle SQL

Practice Questions1 blog

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

Oracle DBA

Practice Questions

OCI 2025 Data Science Professional (1Z0-1110-25)

Practice Questions

More From This Family

Videos and articles for deeper review.

ArticleOracle SQL 1Z0-071 Exam Guide 2026: Official Facts, Topic Traps, and Practice Plan12 min read
2026 Statistics

Key Facts: Oracle 1Z0-078 Exam

60 questions

Oracle 1Z0-078 has 60 multiple-choice and multiple-select questions

Oracle University - 1Z0-078 exam page

120 minutes

Candidates have 2 hours to complete the 1Z0-078 exam

Oracle University - 1Z0-078 exam page

60%

Passing score required for the 1Z0-078 exam

Oracle University - 1Z0-078 exam page

USD 245

Standard exam fee for 1Z0-078 (varies by country)

Oracle University

Oracle Database 19c

The exam targets RAC, ASM and Grid Infrastructure on Oracle 19c

Oracle University - 1Z0-078 exam page

3 redundancy levels

ASM disk groups support external, normal and high redundancy

Oracle ASM Administrator's Guide 19c

OCR and voting disks

Oracle Clusterware stores configuration in the OCR and membership in voting disks

Oracle Clusterware Administration Guide 19c

Pearson VUE

The 1Z0-078 exam is delivered online or at Pearson VUE test centers

Oracle University

Oracle 1Z0-078 'Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration' is an advanced certification exam for experienced Oracle DBAs. It has 60 multiple-choice and multiple-select questions, a 120-minute time limit and a 60% passing score, and costs USD 245 through Oracle University and Pearson VUE. The exam covers Grid Infrastructure and Clusterware (OCR, voting disks, crsctl/srvctl), ASM (disk groups, redundancy, failure groups, rebalancing, Flex ASM and ACFS), RAC administration (services, load balancing, Cache Fusion, node management) and RAC high availability, backup, recovery and tuning. This 100-question bank provides original practice across all of these areas with full explanations.

Sample Oracle 1Z0-078 Practice Questions

Try these sample questions to test your Oracle 1Z0-078 exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which command-line utility is primarily used to manage and check the status of the lower-level Oracle Clusterware stack itself, such as starting and stopping the entire cluster software?
A.srvctl
B.crsctl
C.asmcmd
D.lsnrctl
Explanation: crsctl manages the Oracle Clusterware (CRS) stack, including starting, stopping and checking the cluster software on a node. srvctl manages higher-level resources such as databases, instances, services and listeners.
2What does the Oracle Cluster Registry (OCR) store?
A.Node membership heartbeat data
B.Cluster and resource configuration information
C.Redo log blocks for recovery
D.ASM rebalance progress
Explanation: The OCR stores configuration information about cluster resources, including databases, instances, services, listeners and node applications. Node membership voting is handled separately by voting disks.
3What is the primary purpose of voting disks (voting files) in Oracle Clusterware?
A.To store database datafiles
B.To resolve cluster membership and arbitrate split-brain situations
C.To hold the spfile for ASM
D.To record SQL execution plans
Explanation: Voting files (voting disks) are used by Cluster Synchronization Services to determine which nodes are members of the cluster and to arbitrate during network partitions (split-brain), helping decide which nodes survive.
4In a 19c Grid Infrastructure cluster, what does SCAN (Single Client Access Name) provide to clients connecting to a RAC database?
A.A single name that resolves to multiple cluster VIPs for load balancing and failover
B.A backup copy of the OCR
C.A dedicated private interconnect address
D.A shared storage device for datafiles
Explanation: SCAN provides a single cluster name that typically resolves to three IP addresses via DNS (or GNS). SCAN listeners route incoming connections to the least-loaded instance, so clients need not change when nodes are added or removed.
5How many SCAN IP addresses does Oracle recommend configuring for a typical cluster?
A.1
B.2
C.3
D.5
Explanation: Oracle recommends three SCAN IP addresses (and three corresponding SCAN listeners) for the cluster, regardless of the number of nodes, to provide load balancing and high availability of connections.
6Which Grid Infrastructure feature dynamically assigns virtual IP and SCAN addresses using a DHCP-style mechanism so that you do not have to register them all in corporate DNS?
A.Grid Naming Service (GNS)
B.Oracle Notification Service (ONS)
C.Cluster Time Synchronization Service (CTSS)
D.Cluster Ready Services (CRS)
Explanation: Grid Naming Service (GNS) allows the cluster to manage its own VIP and SCAN name resolution dynamically using DHCP, with corporate DNS delegating a subdomain to GNS. This simplifies adding nodes.
7Which crsctl command checks the status of the entire Oracle Clusterware stack on the local node?
A.crsctl check cluster
B.crsctl status resource -t
C.crsctl check crs
D.crsctl query css votedisk
Explanation: crsctl check crs reports the status of the local Clusterware daemons (CRS, CSS, EVM). crsctl check cluster reports cluster-wide status, while status resource lists resources and query css votedisk lists voting files.
8By default in Oracle Grid Infrastructure, in which type of storage are the OCR and voting files stored when ASM is used?
A.A local file system on each node
B.A shared ASM disk group
C.The database SYSTEM tablespace
D.The Oracle inventory directory
Explanation: When ASM is used for Grid Infrastructure, the OCR and voting files are stored inside a shared ASM disk group (commonly named for example +OCR or +GRID), which provides redundancy according to the disk group's redundancy level.
9Which network is used by Cache Fusion to transfer data blocks and coordination messages between RAC instances?
A.The public client network
B.The private cluster interconnect
C.The storage area network only
D.The management network
Explanation: Cache Fusion uses the private cluster interconnect to ship blocks and Global Cache Service messages between instances. A fast, low-latency, redundant interconnect is critical to RAC performance.
10Which feature, introduced for the cluster interconnect, lets you configure up to four private network interfaces for high availability and load balancing without operating-system bonding?
A.Redundant Interconnect Usage (HAIP)
B.Flex ASM
C.Application Continuity
D.Transparent Data Encryption
Explanation: Redundant Interconnect Usage uses Highly Available IP (HAIP) addresses to support up to four private interconnect interfaces, providing load balancing and failover for the interconnect without requiring OS-level NIC bonding.

About the Oracle 1Z0-078 Exam

The Oracle 1Z0-078 exam, 'Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration', validates a DBA's ability to install, configure, administer and troubleshoot Oracle Grid Infrastructure, Oracle Clusterware, Automatic Storage Management (ASM) and Real Application Clusters (RAC) on Oracle Database 19c. It covers Clusterware components such as the Oracle Cluster Registry and voting disks, ASM disk groups, redundancy, failure groups and rebalancing, RAC database and instance administration, services and connection load balancing, Cache Fusion and global resource coordination, and RAC backup, recovery and performance tuning. The exam is one of the qualifying exams in the Oracle Database 19c clustering high-availability OCP path and assumes substantial hands-on experience.

Assessment

60 multiple-choice and multiple-select questions covering Grid Infrastructure and Clusterware, ASM, Real Application Clusters administration, and high availability, backup, recovery and tuning.

Time Limit

120 minutes (2 hours).

Passing Score

60%.

Exam Fee

USD 245 (varies by country and currency). (Oracle University, delivered through Pearson VUE.)

Oracle 1Z0-078 Exam Content Outline

25%

Grid Infrastructure and Oracle Clusterware

Installing and configuring Grid Infrastructure; managing Oracle Clusterware with crsctl and srvctl; the Oracle Cluster Registry (OCR), Grid Plug and Play and voting disks; managing cluster resources, node membership, SCAN, GNS and the private interconnect; and Clusterware startup, troubleshooting and patching.

25%

Automatic Storage Management (ASM)

Administering ASM instances and disk groups; choosing external, normal and high redundancy; failure groups; allocation units and rebalancing; ASM disk group attributes and compatibility; Flex ASM; ASM Cluster File System (ACFS) and ASM Dynamic Volume Manager; and managing ASM with asmcmd, SQL*Plus and ASMCA.

30%

Real Application Clusters (RAC) Administration

Installing and configuring RAC databases; administering instances and parameters; managing services and workload with srvctl; client-side and server-side connection load balancing and runtime load balancing; Cache Fusion, Global Cache Service (GCS), Global Enqueue Service (GES) and the Global Resource Directory; and adding and deleting cluster nodes.

20%

High Availability, Backup, Recovery and Tuning

RAC backup and recovery with RMAN and the fast recovery area; instance and crash recovery in a cluster; Transparent Application Continuity and Fast Application Notification; monitoring and tuning RAC and Cache Fusion performance with AWR and global cache statistics; and patching the Grid Infrastructure and RAC stack.

How to Pass the Oracle 1Z0-078 Exam

What You Need to Know

  • Passing score: 60%.
  • Assessment: 60 multiple-choice and multiple-select questions covering Grid Infrastructure and Clusterware, ASM, Real Application Clusters administration, and high availability, backup, recovery and tuning.
  • Time limit: 120 minutes (2 hours).
  • Exam fee: USD 245 (varies by country and currency).

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

Oracle 1Z0-078 Study Tips from Top Performers

1Build a small two-node 19c RAC cluster with Grid Infrastructure and ASM in a virtual lab so you can practise crsctl, srvctl, asmcmd and Cache Fusion behaviour hands-on.
2Memorise the practical difference between crsctl (Clusterware/Grid stack) and srvctl (database, instance, service and listener resources) because the exam tests which tool manages which resource.
3Know ASM redundancy levels cold: external (no mirroring), normal (two-way) and high (three-way), and how many failure groups each requires and tolerates losing.
4Understand how Cache Fusion uses the Global Cache Service, Global Enqueue Service and the interconnect to ship blocks between instances rather than writing to disk.
5Practise managing RAC services with srvctl and understand server-side versus client-side load balancing, FAN and runtime load balancing for connection distribution.
6Review RAC RMAN backup and recovery, instance versus crash recovery, and how the OCR and voting disks are protected and restored.

Frequently Asked Questions

How many questions are on the Oracle 1Z0-078 exam and how long is it?

The 1Z0-078 exam has 60 multiple-choice and multiple-select questions and a time limit of 120 minutes (2 hours).

What is the passing score for 1Z0-078?

The passing score is 60%. Oracle determines passing scores statistically and may adjust them as exam content changes.

How much does the 1Z0-078 exam cost?

The exam fee is USD 245, although the price varies by country and currency. You purchase and schedule it through Oracle University and sit it with Pearson VUE.

What does the 1Z0-078 exam cover?

It covers Oracle Grid Infrastructure and Clusterware, Automatic Storage Management (ASM), Real Application Clusters (RAC) administration including services, load balancing and Cache Fusion, and RAC high availability, backup, recovery and tuning on Oracle Database 19c.

Do I need experience before taking 1Z0-078?

There is no formal prerequisite, but Oracle recommends substantial Oracle Database administration experience and hands-on practice with Grid Infrastructure, ASM and RAC before attempting the exam.

Are these official Oracle exam questions?

No. These are original OpenExamPrep practice questions modelled on the 1Z0-078 objectives. Oracle and Pearson VUE provide the official exam separately.