Overview

Practice test for the Oracle exam: 1Z0-078 Oracle Database 19c: RAC,ASM, and Grid InfrastructureValidated on real exam. Nov. 2023. Passing score above 80%.Not all answers fully validated. But good enough to pass the exam with good resultsThis is all questions you need to study/practice for the successful examReview exam topicsRAC Databases and ArchitectureDescribe the benefits of Oracle RACExplain the necessity of global resourcesDescribe global cache coordinationInstalling and Configuring Oracle RACInstall the Oracle database softwareCreate a cluster databaseConvert a single instance Oracle database to RACAdministering Oracle RACDefine redo log files in a RAC environmentDefine undo tablespaces in a RAC environmentStart and stop RAC databases and instancesModify initialization parameters in a RAC environmentManaging Backup and Recovery for RACConfigure the RAC database to use ARCHIVELOG mode and the fast recovery areaConfigure RMAN for the RAC environmentManaging Global ResourcesExplain the need for global concurrency controlDescribe the Global Resource DirectoryExplain how global resources are managedExplain global enqueue and instance lock managementExplain global buffer cache managementExplain use of Affinity to reduce Global Resource ContentionRAC Database Monitoring and TuningIdentify RAC-specific tuning componentsDetermine RAC-specific wait-events, global enqueues and system statisticsImplement the most common RAC tuning practicesUse the Cluster Database Performance pagesUse the Automatic Workload Repository (AWR) in RACUse Automatic Database Diagnostic Monitor (ADDM) in RACRAC Database SGA Runtime ManagementManaging High Availability of ServicesConfigure and manage services in a RAC environmentUse services with client applicationsConfigure services aggregation and tracingManaging High Availability for Connections and ApplicationsConfigure client-side connect-time load balancing and failoverConfigure server-side connect-time load balancingUse the Load Balancing Advisory (LBA)Explain the benefits of Fast Application Notification (FAN)Configure Transparent Application Failover (TAF)Co-location Tag for Client RoutingTransparent Application ContinuityDynamic Services FallbackUpgrading and Patching Oracle RACPlan for rolling patches and rolling updatesInstall a patchset with the Oracle Universal Installer (OUI) utilityInstall a patch with the opatch utilityManaging Oracle RAC One NodeConvert an Oracle RAC One Node database to a RAC databaseUse DBCA to convert a single-instance database to a RAC One Node databaseUsing Oracle Database Quality of Service Management (QoS)Explain the purpose and benefits of using QoSExplain the operation of QoSUsing Multitenant Architecture in a RAC EnvironmentDescribe the multitenant architecture in RAC and non-RAC environmentsCreate a RAC multitenant container database (CDB)Create a pluggable database (PDB) in a RAC CDBUse the default CDB and PDB servicesCreate PDB services to associate PDB services with server poolsAutomated PDB Patching and RelocationGrid Infrastructure AdministrationIntroduction to ClusterwareExplain the principles and purposes of clustersDescribe Cluster hardware best practicesDescribe how Grid Plug and Play affects ClusterwareOracle Clusterware ArchitectureExplain the Oracle Clusterware architectureDescribe Oracle Clusterware startup detailsFlex ClustersExplain the Flex Cluster architecture and componentsDescribe the effect of node failure in a Flex ClusterGrid Infrastructure Installation Planning and Pre-TasksPlan for Grid Infrastructure installationVerify system and network requirementsCreate groups and usersCreate directoriesGrid Infrastructure InstallationInstall Grid InfrastructureVerify the installationConfigure ASM disk groupsOptional Install for the Grid Infrastructure Management RepositoryManaging Cluster NodesPerform the prerequisite steps to extend a clusterDelete a node from a clusterUse DBCA to ADD new nodes to extend the clusterTraditional Clusterware ManagementPerform day to day Clusterware administration tasksPerform Oracle Cluster Registry (OCR) backup and recoveryManage network settingsExplain the scope and capabilities of what-if command evaluationSecure Cluster CommunicationPolicy-Based Cluster ManagementExplain the architecture and components of policy-based cluster managementAdminister server categorizationAdminister a policy setActivate a policyUpgrading and Patching Grid InfrastructureExplain the types of patches and upgrades availablePlan for rolling patches and rolling upgradesCompare software versions with the active versionInstall a patchset with the Oracle Universal Installer (OUI)Install a patch with the opatch utilityZero-Downtime Oracle Grid Infrastructure PatchingTroubleshooting Oracle ClusterwareLocate the Oracle Clusterware log files and use diagcollection.plEnable resource debuggingEnable component-level debuggingTroubleshoot the Oracle Cluster Registry (OCR) fileMaking Applications Highly Available with Oracle ClusterwareExplain the hivh availability components of Oracle ClusterwareExplain policy-managed and administration-managed databasesCreate an application Virtual IP (VIP)Manage application resourcesAutomatic Storage Management (ASM) AdministrationOverview of ASMExplain the Automatic Storage Management (ASM) architectureDescribe the components of ASMAdministering ASM InstancesExplain and apply initialization parameters for ASM instancesManage ASM instances and associated processesMonitor ASM instances using the V$ASM dynamic performance viewsFLEX ASMDescribe the architecture and components of Flex ASMInstall and configure Flex ASMManage Flex ASMAdministering ASM Disk GroupsCreate and delete ASM disk groupsSet the attributes of an existing ASM disk groupPerform ongoing maintenance tasks on ASM disk groupsExplain key performance and scalability considerations for ASM disk groupsAdministering ASM Files, Directories and TemplatesUse client tools to access ASM filesDescribe the format of a fully qualified ASM file nameExplain how ASM files, directories and aliases are created and managedDescribe and manage disk group templatesAdministering Oracle CloudFSAdminister ASM Dynamic Volume ManagerManage ASM volumesImplement ASM Cluster File System (ACFS)Use ACFS snapshotsOracle CloudFS Advance TopicsConfigure ACFS auditingImplement ACFS encryptionConfigure and manage ACFC replicationImplement ACFS taggingConfigure High Availability NFS

Skills

Reviews