Full Name: Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration
Exam Code: 1Z0-078
Oracle 1Z0-078 Exam Details:
| Exam Name | Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration |
| Exam Code | 1Z0-078 |
| Exam Price | USD $245 (Pricing may vary by country or by localized currency) |
| Duration | 120 minutes |
| Number of Questions | 77 |
| Passing Score | 65% |
| Format | Multiple Choice Questions (MCQ) |
| Recommended Training | Oracle Database 19c: RAC Administration Workshop Oracle Database 19c: ASM Administration Workshop Oracle Database 19c: Clusterware Administration Workshop |
| Sample Questions | Oracle Certified Professional, Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administrator (OCE) |
| Recommended Practice | 1Z0-078 Online Practice Exam |
Oracle 1Z0-078 Syllabus Topics:
| RAC Databases and Architecture | - Describe the benefits of Oracle RAC - Describe global cache coordination - Explain the necessity of global resources |
| Installing and Configuring Oracle RAC | - Install the Oracle database software - Convert a single instance Oracle database to RAC - Create a cluster database |
| Administering Oracle RAC | - Define redo log files in a RAC environment - Start and stop RAC databases and instances - Define undo tablespaces in a RAC environment - 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 - Explain global enqueue and instance lock management - Describe the Global Resource Directory - Explain global buffer cache management - Explain how global resources are managed - Explain use of Affinity to reduce Global Resource Contention |
| RAC Database Monitoring and Tuning | - Identify RAC-specific tuning components - Use the Automatic Workload Repository (AWR) in RAC - Determine RAC-specific wait-events, global enqueues and system statistics - Use Automatic Database Diagnostic Monitor (ADDM) in RAC - Implement the most common RAC tuning practices - RAC Database SGA Runtime Management - Use the Cluster Database Performance pages |
| Managing High Availability of Services | - Configure and manage services in a RAC environment - Configure services aggregation and tracing - Use services with client applications |
| Managing High Availability for Connections and Applications | - Configure client-side connect-time load balancing and failover - Configure Transparent Application Failover (TAF) - Configure server-side connect-time load balancing - Co-location Tag for Client Routing - Use the Load Balancing Advisory (LBA) - Transparent Application Continuity - Explain the benefits of Fast Application Notification (FAN) - Dynamic Services Fallback |
| Upgrading and Patching Oracle RAC | - Plan for rolling patches and rolling updates - Install a patch with the opatch utility - Install a patchset with the Oracle Universal Installer (OUI) 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 - Use the default CDB and PDB services - Create a RAC multitenant container database (CDB) - Create PDB services to associate PDB services with server pools - Create a pluggable database (PDB) in a RAC CDB - Automated PDB Patching and Relocation |
| Grid Infrastructure Administration | |
| Introduction to Clusterware | - Explain the principles and purposes of clusters - Describe how Grid Plug and Play affects Clusterware - Describe Cluster hardware best practices |
| 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 - Create groups and users - Verify system and network requirements - Create directories |
| Grid Infrastructure Installation | - Install Grid Infrastructure - Configure ASM disk groups - Verify the installation - Optional Install for the Grid Infrastructure Management Repository |
| Managing Cluster Nodes | - Perform the prerequisite steps to extend a cluster - Use DBCA to ADD new nodes to extend the cluster - Delete a node from a cluster |
| Traditional Clusterware Management | - Perform day to day Clusterware administration tasks - Explain the scope and capabilities of what-if command evaluation - Perform Oracle Cluster Registry (OCR) backup and recovery - Secure Cluster Communication - Manage network settings |
| Policy-Based Cluster Management | - Explain the architecture and components of policy-based cluster management - Administer a policy set - Administer server categorization - Activate a policy |
| Upgrading and Patching Grid Infrastructure | - Explain the types of patches and upgrades available - Install a patchset with the Oracle Universal Installer (OUI) - Plan for rolling patches and rolling upgrades - Install a patch with the opatch utility - Compare software versions with the active version - Zero-Downtime Oracle Grid Infrastructure Patching |
| Troubleshooting Oracle Clusterware | - Locate the Oracle Clusterware log files and use diagcollection.pl - Enable component-level debugging - Enable resource debugging - Troubleshoot the Oracle Cluster Registry (OCR) file |
| Making Applications Highly Available with Oracle Clusterware | - Explain the hivh availability components of Oracle Clusterware - Create an application Virtual IP (VIP) - Explain policy-managed and administration-managed databases - 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 - Monitor ASM instances using the V$ASM dynamic performance views - Manage ASM instances and associated processes |
| FLEX ASM | - Describe the architecture and components of Flex ASM - Manage Flex ASM - Install and configure Flex ASM |
| Administering ASM Disk Groups | - Create and delete ASM disk groups - Perform ongoing maintenance tasks on ASM disk groups - Set the attributes of an existing ASM disk group - Explain key performance and scalability considerations for ASM disk groups |
| Administering ASM Files, Directories and Templates | - Use client tools to access ASM files - Explain how ASM files, directories and aliases are created and managed - Describe the format of a fully qualified ASM file name - Describe and manage disk group templates |
| Administering Oracle CloudFS | - Administer ASM Dynamic Volume Manager - Implement ASM Cluster File System (ACFS) - Manage ASM volumes - Use ACFS snapshots |
| Oracle CloudFS Advance Topics | - Configure ACFS auditing - Implement ACFS tagging - Implement ACFS encryption - Configure High Availability NFS - Configure and manage ACFC replication |
Posts
0 comments:
Post a Comment