1Z0-078 Oracle Database 19c:RAC, ASM, GI; validated Nov 2023
Practice test for 1Z0-078 Oracle Database 19c: RAC, ASM, and Grid Infrastructure; validated in Nov 2023
1Z0-078 Oracle Database 19c:RAC, ASM, GI; validated Nov 2023 free download
Practice test for 1Z0-078 Oracle Database 19c: RAC, ASM, and Grid Infrastructure; validated in Nov 2023
Practice test for the Oracle exam: 1Z0-078 Oracle Database 19c: RAC,ASM, and Grid Infrastructure
Validated on real exam. Nov. 2023. Passing score above 80%.
Not all answers fully validated. But good enough to pass the exam with good results
This is all questions you need to study/practice for the successful exam
Review exam topics
RAC Databases and Architecture
Describe the benefits of Oracle RAC
Explain the necessity of global resources
Describe global cache coordination
Installing and Configuring Oracle RAC
Install the Oracle database software
Create a cluster database
Convert a single instance Oracle database to RAC
Administering Oracle RAC
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
Managing Backup and Recovery for RAC
Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
Configure RMAN for the RAC environment
Managing Global Resources
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
RAC Database Monitoring and Tuning
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
RAC Database SGA Runtime Management
Managing High Availability of Services
Configure and manage services in a RAC environment
Use services with client applications
Configure services aggregation and tracing
Managing High Availability for Connections and Applications
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)
Co-location Tag for Client Routing
Transparent Application Continuity
Dynamic Services Fallback
Upgrading and Patching Oracle RAC
Plan for rolling patches and rolling updates
Install a patchset with the Oracle Universal Installer (OUI) utility
Install a patch with the opatch utility
Managing Oracle 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
Using Oracle Database Quality of Service Management (QoS)
Explain the purpose and benefits of using QoS
Explain the operation of QoS
Using Multitenant Architecture in a RAC Environment
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
Automated PDB Patching and Relocation
Grid Infrastructure Administration
Introduction to Clusterware
Explain the principles and purposes of clusters
Describe Cluster hardware best practices
Describe how Grid Plug and Play affects Clusterware
Oracle Clusterware Architecture
Explain the Oracle Clusterware architecture
Describe Oracle Clusterware startup details
Flex Clusters
Explain the Flex Cluster architecture and components
Describe the effect of node failure in a Flex Cluster
Grid Infrastructure Installation Planning and Pre-Tasks
Plan for Grid Infrastructure installation
Verify system and network requirements
Create groups and users
Create directories
Grid Infrastructure Installation
Install Grid Infrastructure
Verify the installation
Configure ASM disk groups
Optional Install for the Grid Infrastructure Management Repository
Managing Cluster Nodes
Perform the prerequisite steps to extend a cluster
Delete a node from a cluster
Use DBCA to ADD new nodes to extend the cluster
Traditional Clusterware Management
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
Policy-Based Cluster Management
Explain the architecture and components of policy-based cluster management
Administer server categorization
Administer a policy set
Activate a policy
Upgrading and Patching Grid Infrastructure
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
Zero-Downtime Oracle Grid Infrastructure Patching
Troubleshooting Oracle Clusterware
Locate the Oracle Clusterware log files and use diagcollection.pl
Enable resource debugging
Enable component-level debugging
Troubleshoot the Oracle Cluster Registry (OCR) file
Making Applications Highly Available with Oracle Clusterware
Explain the hivh availability components of Oracle Clusterware
Explain policy-managed and administration-managed databases
Create an application Virtual IP (VIP)
Manage application resources
Automatic Storage Management (ASM) Administration
Overview of ASM
Explain the Automatic Storage Management (ASM) architecture
Describe the components of ASM
Administering 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
FLEX ASM
Describe the architecture and components of Flex ASM
Install and configure Flex ASM
Manage Flex ASM
Administering ASM Disk Groups
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
Administering ASM Files, Directories and 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
Administering Oracle CloudFS
Administer ASM Dynamic Volume Manager
Manage ASM volumes
Implement ASM Cluster File System (ACFS)
Use ACFS snapshots
Oracle CloudFS Advance Topics
Configure ACFS auditing
Implement ACFS encryption
Configure and manage ACFC replication
Implement ACFS tagging
Configure High Availability NFS
