MCTS KEY

Format: Multiple-Choice
Duration: 120 Minutes
Number of Questions: 77
Passing Score: 65%
Validation: Exam has been validated for product version Oracle Database 19c
Format: Multiple-Choice
Duration: 120 Minutes
Number of Questions: 77
Passing Score: 65%
Validation: Exam has been validated for product version Oracle Database 19c

Prepare to pass exam: 1Z0-078
The Oracle Certified Expert, Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administrator certification is for Database production Systems Administrators and Database Administrators with 12-18 months of experience using RAC, ASM, and Grid Infrastructure. This exam measures your skills and knowledge on installation, configuration, backup and recovery, monitoring and tuning of these components, and increases your value to your company and the marketplace.

Examkingdom Oracle 1Z0-078 Exam pdf,

Best Oracle 1Z0-078 downloads, Oracle 1Z0-078 Dumps at Certkingdom.com

Take recommended training
Complete one of the courses below to prepare for your exam (optional):
Oracle Database 19c: RAC Administration Workshop
Oracle Database 19c: ASM Administration Workshop
Oracle Database 19c: Clusterware Administration Workshop
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience), in the learning subscription, provides the best preparation for passing the 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

Sample Questions and Answers
 

QUESTION 1
Examine this sequence of commands:
The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

A. The Oracle Clusterware stack is stopped on all nodes.
B. The Oracle Clusterware stack is prevented from being automatically started on host01.
C. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
D. The Oracle Clusterware stack is stopped on all nodes except host01.
E. The Oracle Clusterware stack is started on all nodes except host01.
F. The Oracle Clusterware stack is started on all nodes.

Answer: A, B, F

QUESTION 2
Secure Cluster Communication protects the cluster interconnect from common security threats when
used together with Single Network Support. Secure Cluster Communication includes message digest
mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy
and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?

A. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid
Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database
administrators or cluster administrators do not need to make any configuration changes for this feature.
B. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid
Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an autogenerated
encryption key that is stored locally on each node of the cluster in an Oracle Wallet and
Database administrators or cluster administrators must provide a valid path for the Wallet file.
C. Security for the cluster interconnect is invoked by auto-generated server certificates that will be
assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an
upgrade to Oracle Grid Infrastructure 19c.
D. Database administrators or cluster administrators must provide an encryption key during new
Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure
the interconnect communication.
E. Database administrators or cluster administrators must provide a valid server certificate and an
Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to
Oracle Grid Infrastructure 19c to secure the interconnect communication.

Answer: A

QUESTION 3
Which three resources are managed using global concurrency control in an Oracle 19c RAC multiinstance database? (Choose three.)

A. Database block buffers
B. Mutexes
C. Redo log buffers
D. Latches
E. Enqueues
F. Cursors

Answer: B, D, E

QUESTION 4
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database?
(Choose three.)

A. The source PD3 must be closed on the CDS instance from where the command is executed.
B. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
C. The source pdb must use a global temporary
D. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
E. Oracle Managed Files must be enabled or PD3 file name convert must be set.
F. All running CDB instances must be open in restricted mode.

Answer: A, D, E