Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Oracle
Exam Format
120 min
77
65%
Professional
Registration
Pearson VUE or online proctoring
Validity
Certification does not expire but may need recertification for newer versions
Pass a newer version of the same certification exam; Pass a higher-level certification exam in the same track; Complete Oracle University continuing education
1Z0-078 Exam Topics and Domains
1Z0-078 is organized into 30 weighted domains. Expect to work with DBCA, Services, ACFS, ASM, and more.
1
RAC Databases and Architecture
8%
Oracle RAC Benefits and Architecture
Benefits of Oracle RACGlobal ResourcesGlobal Cache Coordination
- Describe the benefits of Oracle RAC
- Explain the necessity of global resources
- Describe global cache coordination
2
Installing and Configuring Oracle RAC
12%
Oracle RAC Installation
Install Oracle Database SoftwareCreate Cluster DatabaseConvert Single Instance to RAC
- Install the Oracle database software
- Create a cluster database
- Convert a single instance Oracle database to RAC
3
Administering Oracle RAC
15%
RAC Database Administration
Redo Log Files in RACUndo Tablespaces in RACStart and Stop RAC DatabasesModify Initialization Parameters
- Define redo log files in a RAC environment
- Define undo tablespaces in a RAC environment
- Start and stop RAC databases and instances
- Modify initialization parameters in a RAC environment
4
Managing Backup and Recovery for RAC
10%
RAC Backup and Recovery
ARCHIVELOG Mode and Fast Recovery AreaRMAN for RAC
- Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
- Configure RMAN for the RAC environment
5
Managing Global Resources
12%
Global Resource Management
Global Concurrency ControlGlobal Resource DirectoryGlobal Resource Management MechanismsGlobal Enqueue and Instance Lock ManagementGlobal Buffer Cache ManagementAffinity to Reduce Global Resource Contention
- Explain the need for global concurrency control
- Describe the Global Resource Directory
- Explain how global resources are managed
- Explain global enqueue and instance lock management
- Explain global buffer cache management
- Explain use of Affinity to reduce Global Resource Contention
6
RAC Database Monitoring and Tuning
13%
RAC Performance Monitoring and Tuning
RAC-Specific Tuning ComponentsRAC-Specific Wait Events and StatisticsCommon RAC Tuning PracticesCluster Database Performance PagesAWR in RACADDM in RACRAC Database SGA Runtime Management
- Identify RAC-specific tuning components
- Determine RAC-specific wait-events, global enqueues and system statistics
- Implement the most common RAC tuning practices
- Use the Cluster Database Performance pages
- Use the Automatic Workload Repository (AWR) in RAC
- Use Automatic Database Diagnostic Monitor (ADDM) in RAC
- Manage RAC Database SGA Runtime
7
Managing High Availability of Services
10%
Service Management in RAC
Configure and Manage ServicesUse Services with Client ApplicationsServices Aggregation and Tracing
- Configure and manage services in a RAC environment
- Use services with client applications
- Configure services aggregation and tracing
8
Managing High Availability for Connections and Applications
12%
Connection and Application High Availability
Client-Side Connect-Time Load Balancing and FailoverServer-Side Connect-Time Load BalancingLoad Balancing AdvisoryFast Application NotificationTransparent Application FailoverCo-location Tag for Client RoutingTransparent Application ContinuityDynamic Services Fallback
- Configure client-side connect-time load balancing and failover
- Configure server-side connect-time load balancing
- Use the Load Balancing Advisory (LBA)
- Explain the benefits of Fast Application Notification (FAN)
- Configure Transparent Application Failover (TAF)
- Implement Co-location Tag for Client Routing
- Configure Transparent Application Continuity
- Configure Dynamic Services Fallback
9
Upgrading and Patching Oracle RAC
8%
RAC Patching and Upgrades
Rolling Patches and UpdatesPatchset Installation with OUIPatch Installation with OPatch
- Plan for rolling patches and rolling updates
- Install a patchset with the Oracle Universal Installer (OUI) utility
- Install a patch with the opatch utility
10
Managing Oracle RAC One Node
5%
RAC One Node Administration
Convert RAC One Node to RACConvert Single Instance to RAC One Node
- Convert an Oracle RAC One Node database to a RAC database
- Use DBCA to convert a single-instance database to a RAC One Node database
11
Using Oracle Database Quality of Service Management
5%
QoS Management
QoS Purpose and BenefitsQoS Operation
- Explain the purpose and benefits of using QoS
- Explain the operation of QoS
12
Using Multitenant Architecture in a RAC Environment
10%
Multitenant in RAC
Multitenant Architecture in RACCreate RAC Multitenant CDBCreate PDB in RAC CDBDefault CDB and PDB ServicesCreate PDB Services with Server PoolsAutomated PDB Patching and Relocation
- Describe the multitenant architecture in RAC and non-RAC environments
- Create a RAC multitenant container database (CDB)
- Create a pluggable database (PDB) in a RAC CDB
- Use the default CDB and PDB services
- Create PDB services to associate PDB services with server pools
- Implement Automated PDB Patching and Relocation
13
Introduction to Clusterware
8%
Oracle Clusterware Fundamentals
Principles and Purposes of ClustersCluster Hardware Best PracticesGrid Plug and Play
- Explain the principles and purposes of clusters
- Describe Cluster hardware best practices
- Describe how Grid Plug and Play affects Clusterware
14
Oracle Clusterware Architecture
10%
Clusterware Architecture Components
Oracle Clusterware ArchitectureClusterware Startup
- Explain the Oracle Clusterware architecture
- Describe Oracle Clusterware startup details
15
Flex Clusters
8%
Flex Cluster Architecture
Flex Cluster Architecture and ComponentsNode Failure in Flex Cluster
- Explain the Flex Cluster architecture and components
- Describe the effect of node failure in a Flex Cluster
16
Grid Infrastructure Installation Planning and Pre-Tasks
8%
Grid Infrastructure Installation Planning
Plan for Grid Infrastructure InstallationVerify System and Network RequirementsCreate Groups and UsersCreate Directories
- Plan for Grid Infrastructure installation
- Verify system and network requirements
- Create groups and users
- Create directories
17
Grid Infrastructure Installation
10%
Grid Infrastructure Installation Process
Install Grid InfrastructureVerify InstallationConfigure ASM Disk GroupsGrid Infrastructure Management Repository
- Install Grid Infrastructure
- Verify the installation
- Configure ASM disk groups
- Understand optional Grid Infrastructure Management Repository installation
18
Managing Cluster Nodes
8%
Cluster Node Management
Add Nodes to ClusterDelete Nodes from ClusterUse DBCA to Add Database Instances
- Perform the prerequisite steps to extend a cluster
- Delete a node from a cluster
- Use DBCA to ADD new nodes to extend the cluster
19
Traditional Clusterware Management
10%
Day-to-Day Clusterware Administration
Clusterware Administration TasksOCR Backup and RecoveryManage Network SettingsWhat-if Command EvaluationSecure Cluster Communication
- Perform day to day Clusterware administration tasks
- Perform Oracle Cluster Registry (OCR) backup and recovery
- Manage network settings
- Explain the scope and capabilities of what-if command evaluation
- Secure Cluster Communication
20
Policy-Based Cluster Management
8%
Policy-Based Management
Policy-Based Cluster Management ArchitectureServer CategorizationPolicy Set AdministrationActivate Policy
- Explain the architecture and components of policy-based cluster management
- Administer server categorization
- Administer a policy set
- Activate a policy
21
Upgrading and Patching Grid Infrastructure
8%
Grid Infrastructure Patching
Types of Patches and UpgradesPlan for Rolling Patches and UpgradesCompare Software VersionsInstall Patchset with OUIInstall Patch with OPatchZero-Downtime Grid Infrastructure Patching
- Explain the types of patches and upgrades available
- Plan for rolling patches and rolling upgrades
- Compare software versions with the active version
- Install a patchset with the Oracle Universal Installer (OUI)
- Install a patch with the opatch utility
- Implement Zero-Downtime Oracle Grid Infrastructure Patching
22
Troubleshooting Oracle Clusterware
8%
Clusterware Troubleshooting
Locate Clusterware Log FilesEnable Resource DebuggingEnable Component-Level DebuggingTroubleshoot OCR
- Locate the Oracle Clusterware log files and use diagcollection.pl
- Enable resource debugging
- Enable component-level debugging
- Troubleshoot the Oracle Cluster Registry (OCR) file
23
Making Applications Highly Available with Oracle Clusterware
8%
Application High Availability
High Availability ComponentsPolicy-Managed vs Administrator-Managed DatabasesCreate Application VIPManage Application Resources
- Explain the high availability components of Oracle Clusterware
- Explain policy-managed and administration-managed databases
- Create an application Virtual IP (VIP)
- Manage application resources
24
Overview of ASM
8%
ASM Architecture
ASM ArchitectureASM Components
- Explain the Automatic Storage Management (ASM) architecture
- Describe the components of ASM
25
Administering ASM Instances
8%
ASM Instance Administration
ASM Instance Initialization ParametersManage ASM Instances and ProcessesMonitor ASM Instances
- Explain and apply initialization parameters for ASM instances
- Manage ASM instances and associated processes
- Monitor ASM instances using the V$ASM dynamic performance views
26
FLEX ASM
6%
Flex ASM Architecture
Flex ASM Architecture and ComponentsInstall and Configure Flex ASMManage Flex ASM
- Describe the architecture and components of Flex ASM
- Install and configure Flex ASM
- Manage Flex ASM
27
Administering ASM Disk Groups
10%
ASM Disk Group Administration
Create and Delete Disk GroupsDisk Group AttributesDisk Group MaintenancePerformance and Scalability Considerations
- Create and delete ASM disk groups
- Set the attributes of an existing ASM disk group
- Perform ongoing maintenance tasks on ASM disk groups
- Explain key performance and scalability considerations for ASM disk groups
28
Administering ASM Files, Directories and Templates
8%
ASM File and Directory Administration
Access ASM FilesFully Qualified ASM File NamesASM Files, Directories and AliasesDisk Group Templates
- Use client tools to access ASM files
- Describe the format of a fully qualified ASM file name
- Explain how ASM files, directories and aliases are created and managed
- Describe and manage disk group templates
29
Administering Oracle CloudFS
8%
ACFS and ADVM Administration
ASM Dynamic Volume ManagerManage ASM VolumesImplement ACFSACFS Snapshots
- Administer ASM Dynamic Volume Manager
- Manage ASM volumes
- Implement ASM Cluster File System (ACFS)
- Use ACFS snapshots
30
Oracle CloudFS Advanced Topics
8%
Advanced ACFS Features
ACFS AuditingACFS EncryptionACFS ReplicationACFS TaggingHigh Availability NFS
- Configure ACFS auditing
- Implement ACFS encryption
- Configure and manage ACFS replication
- Implement ACFS tagging
- Configure High Availability NFS
How do I earn this certification?
Passing 1Z0-078 earns the Oracle Certified Professional, Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administrator certification. It sits in the Database Administration - RAC track.
Next Level Options
Oracle Certified Master (OCM) - Oracle Database Cloud Certified Master or Oracle Database Certified Master Requires hands-on practical exam and additional coursework
Alternative Paths
- 1Z0-082 - Oracle Database Administration IFoundation-level database administration skills
- 1Z0-083 - Oracle Database Administration IIAdvanced database administration complementary to RAC skills
- 1Z0-084 - Oracle Database 19c Performance and TuningPerformance tuning skills complement RAC administration
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
The most effective way to prepare for 1Z0-078 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
Current Status
- ACTIVE
- Last content update: 2025-10-04
Updates
- Flex ASM 19c Major topic area - includes hub/leaf architecture, cardinality, and remote connections ā¢ Release date: 2019
- Flex Cluster 19c Major topic area - hub nodes, leaf nodes, and failure scenarios ā¢ Release date: 2019
- Multitenant Architecture in RAC 19c Significant topic - CDB/PDB in RAC, services, server pools, automated patching ā¢ Release date: 2019
- Application Continuity 19c Important feature for high availability - TAC, Transaction Guard ā¢ Release date: 2019
- Zero-Downtime Patching 19c Critical operational topic - Fleet Patching and Provisioning, opatchauto ā¢ Release date: 2019
Who should take this exam?
This exam is typically taken by Database Production Systems Administrators and Database Administrators.
- 12-18 months of experience using RAC, ASM, and Grid Infrastructure
- Database production Systems Administration experience
- Database Administrator experience