Exam: 1Z0-078
|
|||||||||||||||||||||||||||
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.
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
1Z0-078 Brain Dumps Exam + Online / Offline and Android Testing Engine & 4500+ other exams included
$50 - $25 (you save $25)
Buy Now
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
Buy Complete
Certainly, here's a rewritten version of your text:
Thomas David 3 weeks ago - USA Maryland
passed yesterday.... legitimate questions...study...and check the comments !!
upvoted 2 times
Rajeev Inampudi 1 week ago - Australia
Passed today. About all new questions included.
upvoted 1 times
Ndlovu Simphiwe 2 weeks ago - South Africa
Still valid, I passed the exam today. I had 5 new questions. Just a hint, go
through the discussion and double-check what is the correct answer.
upvoted 2 times
Robert Madeyo 6 months ago - Uganda
Passed the exam, 49 questions, around just 1 new questions, good luck to
everyone.
upvoted 2 times
Ribesh Pradhan 7 months ago - USA
Questions still valid. Just check the discussion portion for the correct
answers..
Total 50 questions. Got 5 new questions. little exprence should be able to
answer the new questions.
upvoted 1 times
Chinyere Ugorji 8 months ago - USA
Although I passed, I'd say 80 - 90% of questions on my exam were new and not
covered here. This was still useful to learn the concepts, but don't rely on
just memorising correct answers without knowing why they are correct.
upvoted 3 times
logged members Can Post comments / review and take part in Discussion
Certkingdom Offline Testing Engine Simulator Download
Prepare with yourself how CertKingdom Offline Exam Simulator it is designed specifically for any exam preparation. It allows you to create, edit, and take practice tests in an environment very similar to an actual exam.
Supported Platforms: Windows-7 64bit or later - EULA | How to Install?
FAQ's: Windows-8 / Windows 10 if you face any issue kinldy uninstall and reinstall the Simulator again.
Download Offline Simulator-Beta
Certkingdom Testing Engine Features
- Certkingdom Testing Engine simulates the real exam environment.
- Interactive Testing Engine Included
- Live Web App Testing Engine
- Offline Downloadable Desktop App Testing Engine
- Testing Engine App for Android
- Testing Engine App for iPhone
- Testing Engine App for iPad
- Working with the Certkingdom Testing Engine is just like taking the real tests, except we also give you the correct answers.
- More importantly, we also give you detailed explanations to ensure you fully understand how and why the answers are correct.
Certkingdom Android Testing Engine Simulator Download
Take your learning mobile android device with all the features as desktop offline testing engine. All android devices are supported.
Supported Platforms: All Android OS EULA
Install the Android Testing Engine from google play store and download the app.ck from certkingdom website android testing engine download
Certkingdom Android Testing Engine Features
- CertKingdom Offline Android Testing Engine
- Make sure to enable Root check in Playstore
- Live Realistic practice tests
- Live Virtual test environment
- Live Practice test environment
- Mark unanswered Q&A
- Free Updates
- Save your tests results
- Re-examine the unanswered Q & A
- Make your own test scenario (settings)
- Just like the real tests: multiple choice questions
- Updated regularly, always current
